Hi,
We may not have - an out of the box solution to copy posting lines from excel, but we have several options.
You can use the posting template - this allows nearly the same as what you would have in excel maybe better, in that you can mark these as public or private and you can include amounts or percentages.
Additionally, if you have the same supplier such as cellular, health care, utilities that frequently have the same posting lines from month to month you can even set up an invoice template or copy from a previous invoice.
Probably even more common may be a supplier where they would have a single default posting line that may or may not be allocated, the supplier has a default posting string.
From these and others, my experience has been that by using the various options, we can craft a good solution.
Best regards
Using posting templates works well in some situations, but if you need to have some external calculation logic of how to do the postings, it does not. My customer also have the situation that they get invoice specifications from the supplier in an Excel file. By slightly modifying that Excel they have posting lines, but it has to be manually entered to Posting proposal. Would be nice to be able to copy/paste it into posting proposal.
Hi,
If they receive the file via excel, why not load that as an external supplier invoice?
Copy one of the STD templates, make that your template and use that for loading the invoices.
Best regards
They do not receive the actual supplier invoice as a excel. That is arriving as an eInvoice.
22R2 have copy/paste rows in Posting proposal, postings section
I am very curious on that question as well. Is there a good solution to “load” the csv files as posting lines in the proposal?
Greetings,
Benjamin