I have a very simple interaction with our delivery database and our invoice databases from 2020 onward.  When a delivery is complete, the invoice number is entered into the delivery database and the customer's name is brought up.  When all the invoice numbers are entered, a mass update is done to post the date and status to the invoice databases.

Here is the Mass Update:

IF POSTED0 = "" THEN {XPOST("DATA\I-NGV2.DB",INVOICE NUMBER0, "CUSTOMER!INVOICE" , DELIVERY DATE , "DELIVERY DATE","")
                                   POSTED0 = "YES"
                       XPOST("DATA\I-NGV2.DB",INVOICE NUMBER0, "CUSTOMER!INVOICE" , POSTED0 , "CMP","")
                 XPOST("DATA\I-2020V2.DB",INVOICE NUMBER0, "CUSTOMER!INVOICE" , DELIVERY DATE , "DELIVERY DATE","")
                                   POSTED0 = "YES"
                       XPOST("DATA\I-2020V2.DB",INVOICE NUMBER0, "CUSTOMER!INVOICE" , POSTED0 , "CMP","")

                 XPOST("DATA\I-2022V2.DB",INVOICE NUMBER0, "CUSTOMER!INVOICE" , DELIVERY DATE , "DELIVERY DATE","")
                                   POSTED0 = "YES"
                       XPOST("DATA\I-2022V2.DB",INVOICE NUMBER0, "CUSTOMER!INVOICE" , POSTED0 , "CMP","")
                                   
                 XPOST("DATA\I-2023V2.DB",INVOICE NUMBER0, "CUSTOMER!INVOICE" , DELIVERY DATE , "DELIVERY DATE","")
                                   POSTED0 = "YES"
                       XPOST("DATA\I-2023V2.DB",INVOICE NUMBER0, "CUSTOMER!INVOICE" , POSTED0 , "CMP","")
                                   

                 XPOST("DATA\I-2021V2.DB",INVOICE NUMBER0, "CUSTOMER!INVOICE" , DELIVERY DATE , "DELIVERY DATE","")
                                   POSTED0 = "YES"
                       XPOST("DATA\I-2021V2.DB",INVOICE NUMBER0, "CUSTOMER!INVOICE" , POSTED0 , "CMP","")
}

The problem is that it doesn't work for every invoice.  We found the issue with invoice 95085 in 2023.  I retrieved that 1 record in the delivery database and just left the 2023 command lines in the Mass Update.  It still did not work.

Any ideas?

Hi Ray,

I will check that, but if the Xlookup worked, wouldn't the XPost work as well?

Hi Ray,

The computer is at a remote location.  I didn't get a chance to check it more.  When I did the Writeln, the result I go in each database was 95085 without any decimals.  I tried doing an Xlookup for the invoice number from the Delivery database but the result was 0.  I unloaded and unlocked the 2023 database and that didn't change it.

The odd part is that it works on most records, but not all.

I will check the @ERROR this evening.

I tried the @Error, and it says Command Error.

I have a copy of their Delivery Database on my system and tested it against my 2023 database, can got the same results.

Hi Ray,

Yes, there is security on that database.

The delivery database doesn't appear to have xlookup password.

I added an Xlookup password and it seem to work for the record.

I'll try the rest tonight.

Thanks Ray.