I need to assign a percentage of the total amount depending on each item of a sales invoice to a certain accrual account.
E.g. I sold cookies for 100 I want 1% of that to be accrued in some account (for the workers if you would ask)
You need to explain your desire more specifically. In particular, you need to explain what type of account you want to assign the 1% to, and what you plan to do with that account after you make the allocation. “For the workers” is not enough information. Explain the full scenario and what you are trying to accomplish.
What are you selling? If you sell inventory items, a sales invoice results in balancing postings to Inventory on hand (a credit) and Accounts receivable (a debit to the customer’s subsidiary ledger in that account). You can change the control account to which a customer is assigned, but you cannot split the customer. You can also assign inventory items to different control accounts, but again, you cannot split them. Both of those allocations are controlled by your definitions of the customer and the inventory item. They cannot be changed on a sales invoice by any method.
If you are selling services or non-inventory items, credits for those line items can also be posted to different accounts. But if you want to split those allocations, you need multiple line items. And, in the case of non-inventory items, you would need to establish multiple non-inventory item definitions incorporating different posting accounts.
Exactly what I’m doing is:
I buy granite, customer asks for specific shapes and measurements of an item of granite, workers do the work of reshaping the granite and they are paid according to each item of granite worked on (e.g. 1% of the price of each metre of granite worked on), when I generate a sales invoice, I need this calculation to be made automatically and accrued to the workers account (control account) to be paid weekly or monthly.
Also, the invoice total does not change, and the allocated amount doesn’t appear on the invoice because it is irrelevant to it.
I hope this clears the case.
Your explanation is now quite clear. It is also clear that this is not something that has anything to do with sales invoices in Manager, because sales invoices are transactions between your business and your customer, not employees. This is just a piecework pay system. It is unrelated to how much you charge your customer on the sales invoice. Tying this to a sales invoice also would not credit the specific employee who worked on the granite, an essential part of piecework pay systems. And you owe the worker pay regardless of whether the customer pays or not.
The way to handle this is with payslip earnings items and payslips. First, of course, your workers must be defined as employees. Then you must define a payslip earnings item for working granite. Next, you must create payslips for your workers that add the granite payslip earnings item.
Because there is no explicit connection between the sales invoice and the payslip, this cannot be automated. You also do not need any information from the sales invoice to complete the payslip. You only need to know how much granite was involved. Since you know the percentage of the granite price you plan to pay the worker, enter the percentage (as a decimal fraction) in the Unit field and the price of the granite in the Unit Price field. Manager will perform the calculation for you:
A liability to the worker will be created in Employee clearing account. This will be cleared when you pay the employee.
Yes, this may involve extra steps, where you wanted everything automated. But the information to automate the process does not exist. Nor does the program structure allow automation, because there is no accounting reason to base your worker’s pay on what you charge your customer.