Hello,
We are using Transportation Management System for outbound loads.
Given a Freight Bill Invoice (for which we type an Invoice Number), after we submit it for approval, a Vendor Invoice Journal is created, correct.
However, the Invoice Number that we typed on the Freight Bill Invoice, when it reaches the Vendor Invoice Journal gets a “_1” suffix added to it.
If the Freight Bill had several charges, then the Vendor Invoice Journal would have several vouchers (one for each charge, correct) and each voucher would have its Invoice Number with “_1”, “_2”, “_3” etc added as a suffix.
I have seen TechTalk videos where this is seen as standard behaviour but not mentioned at all.
Our issue is that that “_1”, “_2” suffix is not part of the Invoice’s legal number, so we need to manually remove it in every journal. If it is not part of the legal invoice number, it can’t be posted like that, because legislation requires that Tax Reports inform the legal invoice number according to a particular structure, with no extras.
We have not seen a parameter that can take care of this.
Has anyone encountered this behavior, or know if it is possible to get rid of that suffix on the Invoice Number when the Vendor Invoice Journal is created from a TMS Freight Bill Invoice?
Freight Bill Details: Invoice Number does not have the “_1” (apologies, can’t post this image because of being a new user = 1 image per post).
Vendor Invoice Journal: Vendor Invoice Number with the “_1” (because there is only one charge):
Any insight would be extremely helpful.
Thank you and kind regards,
Lucia.