Sales & Purchase Data Output
All Parameters in this Screen.
| Parameter | Description | Input Method | Mandatory |
|---|---|---|---|
| [List Screen] Section | |||
| Display Only | Optional | ||
| Date | Date of each transaction is displayed here. | Display Only | Optional |
| Display Only | Optional | ||
| Contact code | Displays [FUNC]getprm_byid(2,scr,en)[/FUNC]: [FUNC]getprm_byid(1001,prm,en)[/FUNC]. | Display Only | Optional |
| Contact name | Displays [FUNC]getprm_byid(2,scr,en)[/FUNC]: [FUNC]getprm_byid(1002,prm,en)[/FUNC]. | Display Only | Optional |
| Consignee code | This is the [FUNC]getprm_byid(1101,prm,en)[/FUNC] of the consignee contact set for this order. The order's shipping address will be chosen as default. Contacts with which [FUNC]getprm_byid(1003,prm,en)[/FUNC] is set to customer, or consignee in the [FUNC]getprm_byid(2,scr,en)[/FUNC] can be chosen. | Display Only | Optional |
| Consignee name | This is the [FUNC]getprm_byid(1002,prm,en)[/FUNC] of the consignee contact set for this order. The order's shipping address will be chosen as default. Contacts with which [FUNC]getprm_byid(1003,prm,en)[/FUNC] is set to customer, or consignee in the [FUNC]getprm_byid(2,scr,en)[/FUNC] can be chosen. | Display Only | Optional |
| Display Only | Optional | ||
| Display Only | Optional | ||
| Item code | Displays [FUNC]getprm_byid(1,prm,en)[/FUNC] of this entry. | Display Only | Optional |
| Display Only | Optional | ||
| No. | Display Only | Optional | |
| Order No. | Display Only | Optional | |
| Sales order No. | Displays [FUNC]getprm_byid(1301,prm,en)[/FUNC] registered. | Display Only | Optional |
| Product number | Display Only | Optional | |
| Display Only | Optional | ||
| Unit | This is the unit of the item sold. | Display Only | Optional |
| Unit price | Display Only | Optional | |
| Display Only | Optional | ||
| App. tax amount | Display Only | Optional | |
| Tax rate (%) | Displays [FUNC]getprm_byid(20,prm,en)[/FUNC] of this entry. | Display Only | Optional |
| Amount adjustment ([Key currency]) | Displays [FUNC]getprm_byid(5342,prm,en)[/FUNC] in the [FUNC]getprm_byid(5013,prm,en)[/FUNC] defined in the [FUNC]getprm_byid(121,prm,en)[/FUNC] screen). | Display Only | Optional |
| Display Only | Optional | ||
| Sales original cost | This is calculated by multiplying [FUNC]getprm_byid(1803,prm,en)[/FUNC] and [FUNC]getprm_byid(1444,prm,en)[/FUNC]. | Display Only | Optional |
| Sales gross profit | This is the amount of profit gained by this sales order. This is calculated by the following formula. ([FUNC]getprm_byid(1326,prm,en)[/FUNC] - [FUNC]getprm_byid(1803,prm,en)[/FUNC]) x [FUNC]getprm_byid(1444,prm,en)[/FUNC]. |
Display Only | Optional |
| Transaction currency | Displays [FUNC]getprm_byid(2,scr,en)[/FUNC]: [FUNC]getprm_byid(1311,prm,en)[/FUNC]. | Display Only | Optional |
| Currency rate | Displays [FUNC]getprm_byid(1253,prm,en)[/FUNC] applied. | Display Only | Optional |
| Amount adjustment ([Foreign currency]) | Displays [FUNC]getprm_byid(5342,prm,en)[/FUNC] in the [FUNC]getprm_byid(1311,prm,en)[/FUNC] chosen for this customer in the [FUNC]getprm_byid(2,scr,en)[/FUNC]. | Display Only | Optional |
| Display Only | Optional | ||
| Display Only | Optional | ||
| Display Only | Optional | ||
| Sales original cost ([Foreign currency]) | Displays [FUNC]getprm_byid(1804,prm,en)[/FUNC] in [FUNC]getprm_byid(1311,prm,en)[/FUNC] chosen for this customer in the [FUNC]getprm_byid(2,scr,en)[/FUNC]. | Display Only | Optional |
| Sales gross profit ([Foreign currency]) | Displays [FUNC]getprm_byid(1331,prm,en)[/FUNC] in [FUNC]getprm_byid(1311,prm,en)[/FUNC] chosen for this customer in the [FUNC]getprm_byid(2,scr,en)[/FUNC]. | Display Only | Optional |
| Criteria for recording sales | Display Only | Optional | |
| Rounding | It is possible to filter records by the [FUNC]getprm_byid(1020,prm,en)[/FUNC]. | Display Only | Optional |
| Detail remarks | Display Only | Optional | |
| Delivery remarks 1-3 | Displays [FUNC]getprm_byid(1434,prm,en)[/FUNC] of this entry. | Display Only | Optional |
| Invoicing pattern | This is theThis is the[FUNC]getprm_byid(38,prm,en)[/FUNC] set for this Invoice. of the contact set as This is the[FUNC]getprm_byid(1026,prm,en)[/FUNC] set for this Invoice.. | Display Only | Optional |
| Tax unit category | It is possible to filter records by the [FUNC]getprm_byid(1028,prm,en)[/FUNC]. | Display Only | Optional |
| Invoice date | For the Invoice issued, displays the Invoice Date. | Display Only | Optional |
| Invoice No. | This is the Invoice Number generated. | Display Only | Optional |
| Payment/Collection date | Display Only | Optional | |
| Goods in/out location | Display Only | Optional | |
| Staff code | This is the [FUNC]getprm_byid(1161,prm,en)[/FUNC] of the [FUNC]getprm_byid(1309,prm,en)[/FUNC] set for this order. If this parameter appears in the VIEW OPTION, that means this parameter can be used for filtering the records. | Display Only | Optional |
| Staff name | This is the [FUNC]getprm_byid(1162,prm,en)[/FUNC] of the [FUNC]getprm_byid(1309,prm,en)[/FUNC] set for this order. | Display Only | Optional |
| Dept. code | This is the [FUNC]getprm_byid(1151,prm,en)[/FUNC] of the [FUNC]getprm_byid(2567,prm,en)[/FUNC] set for this order. | Display Only | Optional |
| Department name | This is the [FUNC]getprm_byid(1152,prm,en)[/FUNC] of the [FUNC]getprm_byid(2567,prm,en)[/FUNC] set for this order. | Display Only | Optional |
| Contact group code 1-3 | Displays the [FUNC]getprm_byid(1131,prm,en)[/FUNC] of the contact group with which orderer's [FUNC]getprm_byid(1006,prm,en)[/FUNC] is set to in the [FUNC]getprm_byid(2,scr,en)[/FUNC]. | Display Only | Optional |
| Contact group name 1-3 | Displays the [FUNC]getprm_byid(1132,prm,en)[/FUNC] of the contact group with which orderer's [FUNC]getprm_byid(1006,prm,en)[/FUNC] is set to in the [FUNC]getprm_byid(2,scr,en)[/FUNC]. | Display Only | Optional |
| Contact remarks 1-5 | Displays [FUNC]getprm_byid(2,scr,en)[/FUNC]: [FUNC]getprm_byid(1015,prm,en)[/FUNC]. | Display Only | Optional |
| Item group code 1-3 | Displays [FUNC]getprm_byid(1121,prm,en)[/FUNC] of the item group (which is defined in the [FUNC]getprm_byid(4,scr,en)[/FUNC]) to which the [FUNC]getprm_byid(9,prm,en)[/FUNC] of the item delivered belongs to (which is defined in the [FUNC]getprm_byid(1,scr,en)[/FUNC]). | Display Only | Optional |
| Item group name 1-3 | Displays [FUNC]getprm_byid(3034,prm,en)[/FUNC] of the item group (which is defined in the [FUNC]getprm_byid(4,scr,en)[/FUNC]) to which the [FUNC]getprm_byid(9,prm,en)[/FUNC] of the item delivered belongs to (which is defined in the [FUNC]getprm_byid(1,scr,en)[/FUNC]). | Display Only | Optional |
| Item remarks 1-5 | Displays [FUNC]getprm_byid(33,prm,en)[/FUNC] defined in the [FUNC]getprm_byid(1,scr,en)[/FUNC]. | Display Only | Optional |
| Manufacturer | Displays [FUNC]getprm_byid(23,prm,en)[/FUNC] status of this entry. | Display Only | Optional |
| Specification | Displays [FUNC]getprm_byid(24,prm,en)[/FUNC] of this entry. | Display Only | Optional |
| Shelf No. | Displays [FUNC]getprm_byid(25,prm,en)[/FUNC] of this entry. | Display Only | Optional |
| [View Option] Section | |||
| Year & Month | Dropdown List | Mandatory | |
| Dropdown List | Optional | ||
| Dropdown List | Optional | ||
| Purchased Goods Received | Dropdown List | Optional | |
| Externally Manufactured Goods Received | Dropdown List | Optional | |
| Dropdown List | Optional | ||
| Payment | Dropdown List | Optional | |
| Dropdown List | Optional | ||
| Dropdown List | Optional | ||
| Contact code/name | It is possible to filter records by the [FUNC]getprm_byid(217,prm,en)[/FUNC] or the [FUNC]getprm_byid(216,prm,en)[/FUNC] set to the [FUNC]getprm_byid(5541,prm,en)[/FUNC]. | Text Input | Optional |
| Item code/name | It is possible to filter records by the [FUNC]getprm_byid(1,prm,en)[/FUNC] or the [FUNC]getprm_byid(2,prm,en)[/FUNC] registered for this entry. | Text Input | Optional |