17% VAT tax for normal product and goods.
3% VAT tax for small enterprise.
There may be 5% normal business tax (not VAT, not deductible)
Amount tab, cost amount has excluded tax.
There are just so many cost related fields in item table. I here try to map them out one by one with fields in Item Cost Form
Purchased Current Unit Cost:
cur_mat_cost
cur_duty_cost
cur_freight_cost
cur_brokerage
cur_insurance_cost
cur_loc_frt_cost
Manufacturing Current Unit Cost:
cur_matl_cost
cur_lbr_cost
cur_fovhd_cost
cur_vovhd_cost
cur_out_cost
Unit Cost
matl_cost
unit_mat_cost
unit_duty_cost
unit_freight_cost
unit_brokerage_cost
lbr_cost
fovhd_cost
vovhd_cost
out_cost
Unit_Cost
Unit Cost
Current Unit Cost: cur_u_cost
Unit Cost: unit_cost
Assembly
asm_setup
asm_run
asm_matl
asm_tool
asm_fixture
asm_other
asm_fixed
asm_var
asm_outside
Accumulated
comp_setup
comp_run
comp_matl
comp_tool
comp_fixture
comp_other
comp_fixed
comp_var
comp_outside
Standard is from frzcost table.
In order for output print out in Chinese correctly, you will need to set up the font in Language ID form for zh-CN
When creating a new Syteline financial Statement, it is much easier to work on a copy of existing statement report, instead of starting from scratchy. You can certainly use the Excel export/import to do the copying, but one part of the financial statement line, the total tab, would not get copied over that way.
Syteline Financial Statements are stored in the following tables.
1) glrpth statement definition
2) glrpthc statement columns definition
3) glrptl statement lines definition
4) glrptls statement lines definition, total tab, line add up
5) glrptlc statement lines definition, total tab, column defined.
By using Excel import, only the above 4) would not get copied over correctly. You may use the following script to get the copy completed.
insert into glrptls
(rpt_id, seq, from_seq, to_seq, total_add)
select
‘New_Report_ID’, seq, from_seq, to_seq, total_add
from glrptls tt1 where tt1.rpt_id = ‘Old_Report_ID’
One thing to remember, before running the above script, re-set sequence for both new and old report, make them both start from 10 and increment by 10. This is to ensure both have the identical sequence. Or, better yet, before you do the Excel import/export, re-set the sequence in old report.
Recent Comments