Thank You
but should the QUANTITY of the "Out" transactions not equal the "QTY_USED" of the "In" transactions unless the stock is negative in which case it will match the shortfall?
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
Search found 2 matches
- 27 Mar 2025, 17:04
- Forum: Sage 50 UK version General Help
- Topic: Stock Transaction Reconciliation
- Replies: 3
- Views: 34260
- 27 Mar 2025, 12:03
- Forum: Sage 50 UK version General Help
- Topic: Stock Transaction Reconciliation
- Replies: 3
- Views: 34260
Stock Transaction Reconciliation
I am using the Sage 50 ODBC connector and trying to reconcile the QTY_IN_STOCK from the STOCK table for each STOCK_CODE. I am assuming that this should equal the sum of the QUANTITY in the STOCK_TRAN table excluding DI and DO transaction types - however I am getting over 200 discrepancies - would ...