x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 96 subscribers
  • Views 1129 views
  • Users 0 members are here
Browse Forums
Announcements
150
topics
113
replies
General Discussion
5k
topics
13k
replies
Payroll & Tax
632
topics
892
replies
Reporting and Analytics
573
topics
1k
replies
Service Alerts
1
topics
0
replies
Software Development Kit (SDK)
435
topics
671
replies
Year End
83
topics
128
replies
fsg

Items sold to customers report does not show cost of sales / services due to date differences in sales and purchases

SUGGESTED
Posted By

Hi,

when I create and submit an advance invoice for sales / services for a customer e.g dated 1st-Jan-2018 and the vendor provides the material & invoices it on 2nd-Jan-2018, I've noticed that COS does not show in the Items sold to customers report. Is this some kinda of bug or because the vendor's bill date is later than the customer's invoice date? As per our management we could not change the date of the customer invoice after the vendors bill date because we've created many advance customer invoices as per customer request and also our dept. suggested to make a single invoice for a single order to receive timely payment from customers. Any suggestions on how to solve this issue?

Thanks,

BR,

Yasin 

  • 0
    SUGGESTED

    It is not a bug in the software. The Item ID that has an Item Type of Service takes the cost that currently exists in the field called last cost when that item ID is used in an invoice. For example lets say you purchase service item S1 where you pay 25.00 for that service. Then another purchase is entered for S1 on the same day where you pay 35.00. If you enter a sales invoice on that same day but after the 2nd purchase is entered, the cogs will be 35.00, not 25.00.

    I think the only way you can do this is to add a Job ID on every purchase and the same job ID for every sale. So for Invoice 1001 dated 5/1/2018 you use a Job 1001. When you enter your purchase for that service dated 5/4/2018 for 25.00 use Job #1001. Invoice 1002, use Job 1002 and enter all the purchases related to invoice 1002 to job 1002.  Now you can run a job profitability report that should give you what you are looking for.

    Hope that helps you resolve your issue.

*Community Hub is the new name for Sage City