Hi everyone, We have a problem every month end w...
# general
k
Hi everyone, We have a problem every month end where we notice a couple of our item fulfillments are in one month and invoices dated in the next month. This is usually the case when the item is fulfilled near the end of the month and then they get invoiced a couple of days later which will be the next month. This causes an issue as COGS and revenue aren't the true value for that period. Is there a feature that can be turned on or anything else to fix this rather then fixing it manually every month?
e
We have a workflow that creates the invoice automatically, as soon as the IF is created. That way both documents are always in the same period.
❤️ 1
k
Oh awesome! Might do the same thing. Thank you
a
Also, not sure if you use Pick\Pack\Ship, but the cogs hit posts on the transaction date. Sometimes fulfillments are created in one month and then shipped in another. I've put in a script for some clients that will update the trandate based on the date shipped. May want to check into that as well.
👍 1
k
Thank you! Yeah, that's been our issue as well. Moment status is changed to Shipped that's when it hits the COGS. Only problem is we don't have a dev to create a script for us
@Edgar Valdes do you mind sharing screenshots or how you created your workflow?
e
Sure @Koon Kabob The Workflow runs on Sales Order. It is scheduled to run every 30 minutes.
It uses a Saved Search of Sales Order that are Pending Bill
This is the Saved Search
The Workflow has a single State, where double checks the Sales Order Status, and transform to Invoice
This is the Action itself, nothing more except the condition of sales order status
k
@Edgar Valdes Thank you so much! This worked for us as well :)
1