Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help! net_sls_ttl doesn´t match with chk_begun_ttl

Status
Not open for further replies.

Daniel SA

Systems Engineer
Jun 11, 2019
3
MX
In the Daily Revenue Report there is something strange, the net sales are different from the met sales in the section of order type.

Looking at the tables I found that the net_sls_total have a -153 and that is the sum of 3 products (product price without IVA - product price)

I don´t know what really is happening, the record_type is S

Thanks for helping
 
Here is how micros works:

chk_begun_ttl is the total sales amount started (negatives + positives) for that day

net_sls_ttl is the total sales entered (negatives + positives) for that day.

Here is a scenario:

Day 1:

Ring up $500 worth of sales. Actually final tender $100 worth because the other $400 was someone quoting someone.
Net sales: $500
Check begun total: $500

Day 2:

Ring in $100 worth of sales and pay for $100 worth of sales. Void out and close the other $400 worth of open checks from the previous day.

Net sales: -$300
Check begun total: $100


Make sense? Someone correct me if I got that wrong, I don't really deal with accounting stuff often.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top