I am stuck with a riddle ) I'm a newbie still don't know much. Any help is highly appreciated.
I have several tables:
I have two things that I need:
1. when I create sales invoice in Operations, I need to create several records in operations with same AnalyticTag (column) as in created Invoice, but different Expense category (column).
1.1 These records must be either profiled, or either from template - but this is different story I guess.
2. Also, when I create customer or Accounts, or add new currency - I need to create rows in ACC table. For example, I have Customer 1, Account 1 and Currency 1, 2, 3
What I need is, when creating customer or account record, or adding new currency record, have a table in ACC like this:
row 1 customer 1 currency 1
row 2 customer 1 currency 2
row 3 customer 1 currency 3
row 4 account 1 currency 1
row 5 account 1 currency 2
row 6 account 1 currency 3
when I add new customer or account - same should be done, but when I create new currency, all lists should be updated. for example, is currency 4 is created, we need to create row 7 for customer 1, currency 4 and row 8 for account 1 currency 4.
Basically, I have ACC table for calculating profit and losses.
because I have several currencies I need the to be recorded as separate records for each object in ACC to calculate everything.
and when I add saes invoice to operations, I want to records 5 (in future pre-filled or from template) to same table, with same analytic ID as my invoice, so then I can filter them out from view, to know which expense records I still have to record.