Hi
Please help me with below - thanks heaps
Please help me with below - thanks heaps
1 H | I | J | K | L | M | N | O | |
2 Currency Code | Gen Posting Type | Gen Bus. P.. | Gen. Prod. | GSTBus. P... | Branch Code | Amount | GST Amount | |
3 | Sale | GEN | GEN | CUSTOMER | 125 | -14,427.68 | -1,311.61 | |
4 | Sale | GEN | GEN | CUSTOMER | 125 | |||
5 | 125 | 2,240.60 | 0 | |||||
6 | 125 | 12,445.38 | 0 | |||||
7 | Sale | GEN | GEN | CUSTOMER | 125 | -3.71 | -0.34 | |
8 | ||||||||
9 Till Variance | 3.71 | Tax | $1,311.27 | |||||
Queries Below | ||||||||
If i9 is positive then n7 should show negative | ||||||||
If i9 is negative then n7 should show positive | ||||||||
If n7 is negative then n3 should be tax L9 less N7 and multiply with 11 , After this calculation N3 shd still show have negative sign | ||||||||
If n7 is positive then n3 should be tax L9 plus 3.71 and multiply with 11 , After this calculation N3 shd still show have negative sign |