Help needed with invoicing
Hi, it's been a while since l have posted but have come across a problem l don't know how to rectify.
l have an Invoice table linked to a Customer table, and in my Customer table l have set up a customer called "Shop Sale".
"Shop Sale" customers are radom walk ins who purchase items from my store as opposed to a Customer who might have multiple sales over a long period of time and might have other tables linked.
The situation l am having is that a Sale created in January with a date and invoice number can suddenly change to the date of the last sale made, ie, today's date. I have a "Report" table with a view including date parameters and totals and am wondering if when using it somehow changes all "Shop Sales" to one date.
this is causing a lot of issues as l have to go back and change all the invoice dates back to original invoice date.
any advice would be very helpful.
Also, is their anyone out there who is using and is able to help me and lives in Melbourne Australia?
3 replies
-
Hi Michael -
Do you have any trigger code or do you only notice this when you go to your Reports dashboard?
What is the code you have in your Reports table view?
-
Hi Fred, on the customer table l do have a script in a button to automatically open a "Shop Sale" invoice and which auto fills the date. The script for button is
let newRec:=(create Invoices);
newRec.(Customer:=133);
popupRecord(newRec)
l did have an auto fill date code as well but removed yesterday, thinking this could be part of the problem.
I have a trigger on create in Invoice'Invoice ID := text(record(Counters,1).Result);
let c:=record (Counters,1).Counter +1;
job_:="Job-" + format(c,"0000");
'Type of Sale ' := null
The counter works perfectly and this code was given to me by Sean from a Webinar.
The code for reports is one l got from a YouTube Nioxus Classlet xBeg := 'Beg Date';
ler xEnd := 'End Date';
sum(( select Invoices) ['Date of Invoice'>=xBeg and 'Date of Invoice' <= xEnd].'Total inc GST')
that covers all scripts and triggers.
hope this helps.
'regards MIchael -
You reference an auto fill date code but didn't post it. Since you removed it have you had any issues?
The other code you posted don't seem to touch any date fields so I don't see anything there.
Content aside
- 2 yrs agoLast active
- 3Replies
- 534Views
-
1
Following