0

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?

5 replies

null
    • Fred
    • 2 yrs ago
    • Reported - view

    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?

    • DELETEDsheikhmbuga5
    • 2 yrs ago
    • Reported - view

    SSD Chemical Solution for cleaning black money +27735257866 in South Africa Zambia,Zimbabwe,Botswana,Lesotho,Swaziland,Somalia,Namibia,Qatar,Egypt,UAE,USA,UK,Turkey,Hong Kong,DRC,China,Ethiopia,Eritrea,Sudan,Morocco,Brunei,Japan,Algeria,Thailand,Tunisia,Kenya,Spain,Italy,Tanzania,Bahamas,Taiwan,Indonesia,Singapore,Czech Republic,Serbia,Palau,Lithuania,Malaysia,Myanmar,Kuwait,Fiji,Jordan,Yemen,Bahrain,Philippines,Israel....SSD chemical solution for sale in UAE, SSD chemical solution for sale USA, clean black money in China, SSD solution for sale in Japan, SSD chemical solution and activation powder for sale in South Africa, SSD chemical solution in Zambia, SSD chemical solution price in Lesotho, SSD chemical solution for sale in Zimbabwe, SSD solution price in Botswana, SSD chemical solution online, SSD chemical solution in Egypt, SSD solution chemical suppliers in United Kingdom, SSD chemical solution and activation powder for sale, SSD solution price in Turkey, SSD solution suppliers , SSD solution chemical suppliers in Tanzania, SSD solution in Indonesia, SSD solution in Spain, SSD solution in Swaziland, black dollar cleaning chemical in Canada, SSD chemical formula in Singapore, black dollar cleaning machine, black money cleaning machine suppliers, how to clean black money. https://paparazaq.blogspot.com http://bestssdchemicalsolution.over-blog.com http://mbugassdsolution.website2.me Call/ Whatsapp On +27735257866 or Email: sheikhmbuga5@gmail.com

    • Central Park Furnishings
    • Michael_McKenna
    • 2 yrs ago
    • Reported - 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 Class

    let 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 

    • Fred
    • 2 yrs ago
    • Reported - view

    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.

    • nurse
    • kerissa_Jacob
    • 2 yrs ago
    • Reported - view

    I was married at 32 and immediately tried to get pregnant. When I was unable to conceive I had blood tests for fertility and was told that I had an FSH (follicle stimulating hormone) of 54 and would not be able to have children. Even though the doctors knew that I had been diagnosed with Hashimoto’s thyroiditis since age 25, no one bothered to check my thyroid levels. my TSH was measured at .001. My Synthroid dosage was lowered. a friend advise me to contact a spiritualist who help with fertility with his medicine, i collected his contact and explain my situation to him he prepared for me a herbal medicine which i took as describe by him. became pregnant very quickly, I had a successful pregnancy. I have my baby august 2019 to get pregnant at age 35 with my 2nd child in September 2022, thank you sir , this is his email contact if you require his help babaka.wolf@gmail.com or Facebook at priest.babaka

Content aside

  • 2 yrs agoLast active
  • 5Replies
  • 503Views