GST Statement - Capture Payment alone from G/L-A/c

Business Central/NAV Developers Forum
1

Hi, When I am trying to create a GST statement, I am facing this problem. Iam taking a G/L Account (used to store GST Amount). In that GL account there are entries with the Following document types. Invoice, Cr. Note, Payment, etc. I want to pick the only the sum of payment made form that account. How can I do this. can any one help on this Regards M. Ramanath

2

quote:

Originally posted by ramanathmani
Hi, When I am trying to create a GST statement, I am facing this problem. Iam taking a G/L Account (used to store GST Amount). In that GL account there are entries with the Following document types. Invoice, Cr. Note, Payment, etc. I want to pick the only the sum of payment made form that account. How can I do this. can any one help on this Regards M. Ramanath

You should apply a filter on “Document Type” in G/L Entry table. If you want the sum stored in a flow field on the G/L Account table, you must first add a key on the G/L Entry table including at least “G/L Account No.” and “Document Type” as keyfields and a sumindex field on Amount, then you can add a fielf on G/L Account table, class FlowField, CalcFormula: Sum(“G/L Entry”.Amount WHERE (G/L Account No.=FIELD(No.),Document Type=CONST(1))) I hope this hepls Anna

3

Hi, Where u can write this code in the GST statement…? In G/L - Per.Act–> GST Stmt. Line… We have only option to select the available values with the given types. Can u let me know where we can do this… Rgds M. Ramanath

4

quote:

Originally posted by ramanathmani
Hi, Where u can write this code in the GST statement…? In G/L - Per.Act–> GST Stmt. Line… We have only option to select the available values with the given types. Can u let me know where we can do this…

What I was suggesting is a change in tables 15 (G/L Account) and 17 (G/L Entry); I don’t know what a GST statement is, that is I don’t know how it translates into Italian. [:I] I turned my NA 3.60 database to English, but wasn’t able to recognize the point you are trying to modify. If you might provide the object number, maybe I could manage to help you better. [:p] Anna