Hello All,
I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…
Hello All,
We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty.
SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts
In the below example, in main I m seeing a open PO qty but in…
Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…
I'm wanting to add about 600 items to an already existing list of products in our datasbase.
So, I exported 3 lists:
I opened I/C “Items”. I created a script that would contain all the columns we use in that first tab (of the Items Module), and the…