Alex_Excel
New Member
- Joined
- Apr 9, 2015
- Messages
- 7
Hello,
say I have multiple invoices that are all made the same way. Different VAT tax codes are invoiced. Total invoice = amount without tax + tax. These different VAT codes go into different rows in a second tab that specifies the tax code.
For example:
[TABLE="width: 1136"]
<tbody>[TR]
[TD]Site ID[/TD]
[TD]Document Date[/TD]
[TD]Doc. Nr[/TD]
[TD]Amount 0%[/TD]
[TD]Amount 6%[/TD]
[TD]Amount 12%[/TD]
[TD]Amount 21%[/TD]
[TD]Amount 21% N-Food[/TD]
[TD]Total[/TD]
[TD]Costcenter[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]484[/TD]
[TD]14032015[/TD]
[TD]1817/290453[/TD]
[TD] 50,00[/TD]
[TD] 435,41[/TD]
[TD] 100,00[/TD]
[TD] 121,00[/TD]
[TD] 75,00[/TD]
[TD] 781,41[/TD]
[TD]3B2S000484[/TD]
[/TR]
</tbody>[/TABLE]
Should give me the following:
[TABLE="width: 535"]
<tbody>[TR]
[TD]Posting date[/TD]
[TD]Document date[/TD]
[TD]Doc Type[/TD]
[TD]Pk[/TD]
[TD]Account number[/TD]
[TD]Amount[/TD]
[TD]Tax code[/TD]
[TD]Cost Center[/TD]
[/TR]
[TR]
[TD]24032015[/TD]
[TD]14032015[/TD]
[TD]KR[/TD]
[TD]31[/TD]
[TD]246851[/TD]
[TD]781,41[/TD]
[TD]**[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24032015[/TD]
[TD]14032015[/TD]
[TD]KR[/TD]
[TD]40[/TD]
[TD]60711000[/TD]
[TD]50,00[/TD]
[TD]z0[/TD]
[TD]3B2S000484[/TD]
[/TR]
[TR]
[TD]24032015[/TD]
[TD]14032015[/TD]
[TD]KR[/TD]
[TD]40[/TD]
[TD]60711000[/TD]
[TD]435,41[/TD]
[TD]v1[/TD]
[TD]3B2S000484[/TD]
[/TR]
[TR]
[TD]24032015[/TD]
[TD]14032015[/TD]
[TD]KR[/TD]
[TD]40[/TD]
[TD]60711000[/TD]
[TD]100,00[/TD]
[TD]v2[/TD]
[TD]3B2S000484[/TD]
[/TR]
[TR]
[TD]24032015[/TD]
[TD]14032015[/TD]
[TD]KR[/TD]
[TD]40[/TD]
[TD]60711000[/TD]
[TD]121,00[/TD]
[TD]v3[/TD]
[TD]3B2S000484[/TD]
[/TR]
[TR]
[TD]24032015[/TD]
[TD]14032015[/TD]
[TD]KR[/TD]
[TD]40[/TD]
[TD]60690000[/TD]
[TD]75,00[/TD]
[TD]v3[/TD]
[TD]3B2S000484[/TD]
[/TR]
</tbody>[/TABLE]
Is there any way of referencing this so that when I add another row of information about the invoice, automatically 6 rows extra are created that refer to 1 new row ?
Thanks in advance,
Alex_Excel
say I have multiple invoices that are all made the same way. Different VAT tax codes are invoiced. Total invoice = amount without tax + tax. These different VAT codes go into different rows in a second tab that specifies the tax code.
For example:
[TABLE="width: 1136"]
<tbody>[TR]
[TD]Site ID[/TD]
[TD]Document Date[/TD]
[TD]Doc. Nr[/TD]
[TD]Amount 0%[/TD]
[TD]Amount 6%[/TD]
[TD]Amount 12%[/TD]
[TD]Amount 21%[/TD]
[TD]Amount 21% N-Food[/TD]
[TD]Total[/TD]
[TD]Costcenter[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]484[/TD]
[TD]14032015[/TD]
[TD]1817/290453[/TD]
[TD] 50,00[/TD]
[TD] 435,41[/TD]
[TD] 100,00[/TD]
[TD] 121,00[/TD]
[TD] 75,00[/TD]
[TD] 781,41[/TD]
[TD]3B2S000484[/TD]
[/TR]
</tbody>[/TABLE]
Should give me the following:
[TABLE="width: 535"]
<tbody>[TR]
[TD]Posting date[/TD]
[TD]Document date[/TD]
[TD]Doc Type[/TD]
[TD]Pk[/TD]
[TD]Account number[/TD]
[TD]Amount[/TD]
[TD]Tax code[/TD]
[TD]Cost Center[/TD]
[/TR]
[TR]
[TD]24032015[/TD]
[TD]14032015[/TD]
[TD]KR[/TD]
[TD]31[/TD]
[TD]246851[/TD]
[TD]781,41[/TD]
[TD]**[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24032015[/TD]
[TD]14032015[/TD]
[TD]KR[/TD]
[TD]40[/TD]
[TD]60711000[/TD]
[TD]50,00[/TD]
[TD]z0[/TD]
[TD]3B2S000484[/TD]
[/TR]
[TR]
[TD]24032015[/TD]
[TD]14032015[/TD]
[TD]KR[/TD]
[TD]40[/TD]
[TD]60711000[/TD]
[TD]435,41[/TD]
[TD]v1[/TD]
[TD]3B2S000484[/TD]
[/TR]
[TR]
[TD]24032015[/TD]
[TD]14032015[/TD]
[TD]KR[/TD]
[TD]40[/TD]
[TD]60711000[/TD]
[TD]100,00[/TD]
[TD]v2[/TD]
[TD]3B2S000484[/TD]
[/TR]
[TR]
[TD]24032015[/TD]
[TD]14032015[/TD]
[TD]KR[/TD]
[TD]40[/TD]
[TD]60711000[/TD]
[TD]121,00[/TD]
[TD]v3[/TD]
[TD]3B2S000484[/TD]
[/TR]
[TR]
[TD]24032015[/TD]
[TD]14032015[/TD]
[TD]KR[/TD]
[TD]40[/TD]
[TD]60690000[/TD]
[TD]75,00[/TD]
[TD]v3[/TD]
[TD]3B2S000484[/TD]
[/TR]
</tbody>[/TABLE]
Is there any way of referencing this so that when I add another row of information about the invoice, automatically 6 rows extra are created that refer to 1 new row ?
Thanks in advance,
Alex_Excel