I am looking for a Query or BAQ to display the items sold, price, and quantity that comprise up the income statement on two accounts. I am struggling to determine a way to compare the values that comprise the two accounts that I am trying to match up to Shipped Products. Any thoughts??
Userlevel 3
Shipments should relate back to order or jobs and you can join that way.
Userlevel 3
to be thorough, you could link from the GL Account via TranGLC table to the invoice.
Invoice Detail should include quantity, revenue, and cost.
Userlevel 1
I went into the GL Controls and added source document descriptions, so every transaction posted to the GL can be easily traced back. There are a few posts here on EUG about it.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.