AQL023 のバックアップ(No.14)

Sales order batch entry †

Order control
- Sales order batch entry
two or more Order information from a customer is edited in Excel (CSV), the Order information is summarized on a number screen, and Read-in sees it.

Query item name	Explanation
File name	Specify the full path of the storing place and File name of a file which perform Batch processing.
Register type	It is Selection about any of AddEntry or Change they are.

Query Condition can be specified and CSV download for package Change can be Output(ed).

Query item name	Explanation
Customer
Place of delivery
Billing
Customer purchase No...
Customer item
Plant item
Delivery date	FROM - TO is specified.

↑

Upload file layout †

In the case of Add specification

Input item name	Character	Number of bits	Mandatory	Explanation
Customer	alphabet/number	6	○	Customer code Entr(ied) by Customer master is inputted.
Place of delivery	alphabet/number	8	○	Place of delivery code Entr(ied) by Place of receipt master is inputted.
CustomerOrderNO	alphabet/number/symbol	20	○	A customer's order number is inputted.
CustomerOrderLine number	number	5		Brunch number in case two or more Order information exists in Customer purchase No. In a No.t input, 0 is set.
Customer item	-	30	○	Customer item Entr(ied) by Primary table for customer item change information is inputted.
Customer revision	alphabet/number	4		Revision of Customer item is inputted. In a No.t input, Revision of Primary table for customer item change information is set.
Item name	-	40		Item name of Plant item
Unit price	number	16,4		At the time of a No.t input, when cannot set Sale Unit price and it cannot be acquired and acquired from Sales unit price master, 0 is set.
Delivery date	year/month/date	-	○	Customer Delivery date is inputted. Time can also be No.t inputted.
Order quantity	number	12,4	○	Order quantity is inputted.
Production number	alphabet/number/symbol	10		Production number Entr(ied) by Production number ledgermaster is inputted. ※It becomes possible to change to automatic numbers in a system parameter. 　As an automatic numbers system, they are two kinds, the Production number management No and Order No.
Place of delivery (EDI)Code	-	10		It inputs as Details of Place of delivery. ※Code-Master table management is not carried out within a system.
Delivery destination	-	3		It inputs as Delivery destination of Place of delivery. It is displayed on Shipping instruction sheet and Shipping details and advanced shipping notice.※Code-Master table management is not carried out within a system.
ShippingInspection classification	-	2		It inputs by setting the contents of an inspection at the time of Shipping to Classification. ※Code-Master table management is not carried out within a system.
Direct delivery	number	1		In SupplierDirect delivery, '1' is inputted.
Remarks	-	100		The supplement of Correct reason, etc. are inputted at the time of the special affairs to Order information, or Change.
Billing	alphabet/number	6	-	Customer code Entr(ied) by Customer master is inputted.
Billing item name	alphabet/number	30	-	Item of Billing is inputted.
BillingOrderNO	alphabet/number/symbol	30	-	The order number of Billing is inputted.

In the case of Change specification

No..	Input item name	Character	Number of bits	Mandatory	Update is possible	Explanation
1	OrderNO	alphabet/number	14	○	-	OrderNO (form of OrderNO-Order details No) Entr(ied) by Sales order list is inputted.
2	Customer	alphabet/number	6	-	-	Customer code Entr(ied) by master is inputted.
3	Customer item	alphabet/number	30	-	-	Customer item Entr(ied) by Primary table for customer item change information is inputted.
4	CustomerOrderNO	alphabet/number/symbol	30	○	○	A customer's order number is inputted.
5	Customer line number	number	5	-	○	Brunch number in case two or more Order information exists in Customer purchase No.
6	Salesperson	alphabet/number	6	-	○	Salesperson is inputted.
7	Order date	year/month/date	-	○	○	Order date is inputted.
8	Place of delivery	alphabet/number	8	-	○	Place of delivery code Entr(ied) by master is inputted.
9	Revision	alphabet/number	4	-	○	Revision of Customer item is inputted.
10	Production number	alphabet/number/symbol	10	-	○	Production number Entr(ied) by Production number ledgermaster is inputted. ※It becomes possible to change to automatic numbers in a system parameter. 　As an automatic numbers system, they are two kinds, the Production number management No and Order No.
11	Sales unit price	number	16,4	-	○	At the time of a No.t input, when cannot set Sale Unit price and it cannot be acquired and acquired from Sales unit price master, 0 is set.
12	Unit price classification	alphabet/number	1	-	○
13	Correct reason	alphabet/number	2	○	○	Correct reason set up in the introductory company is inputted.
14	Inspection classification	alphabet/number	2	-	○
15	Place of delivery (EDI)	alphabet/number	10	-	○	It inputs as Details of Place of delivery. ※Code-Master table management is not carried out within a system.
16	Delivery destination	alphabet/number	3	-	○	It inputs as Delivery destination of Place of delivery. It is displayed on Shipping instruction sheet and Shipping details and advanced shipping notice. ※Code-Master table management is not carried out within a system.
17	Remarks	-	100	-	○	The supplement of Correct reason, etc. are inputted at the time of the special affairs to Order information, or Change.
18	Billing	alphabet/number	6	-	○	BillingCode Entr(ied) by Customer master is inputted.
19	Billing item name	alphabet/number	30	-	○	Item of Billing is inputted.
20	BillingOrderNO	alphabet/number/symbol	30	-	○	The order number of Billing is inputted.
21	Order quantity	number	12,4	○	○	Order quantity is inputted.
22	Delivery date	year/month/date	-	○	○	Delivery date is inputted.
23	Scheduled shipping date	year/month/date	-	-	○	Scheduled shipping date is inputted. ※In a No.t input, Date which pulled Delivery date to Transportation leadtime is set.
24	Order STS	number	-	○	○	Order status is inputted. ※STS items(1:Confirm ,2:Complete,9:Cancel )。
25	Direct delivery	number	-	○	○	In SupplierDirect delivery, '1' is inputted.

↑

CSV download for package Change †

Download CSV for Package Change.

An output procedure becomes as follows.
①It is arbitrary and specify CSV downloard condition for Batch change.※In Shipping status, the thing of Unshipped and Partially shipped serves as Output object.
②CSV output if a download button is click(ed).
③Please Change the contents of CSV after download, set Register type to Change, and perform upload processing.

↑

Confirm of Sales order batch entry †

Confirm whether there is any error in the contents of a file before carrying out Batch entry.

A Confirm procedure becomes as follows.
①Start 【Sales order batch entry】, click the 〔Reference〕 button of File name, and specify the file which uploads.
②If the Confirm button is click(ed), Confirm processing will start.
③Since a List indication of the Confirm result will be given if the 〔Result confirmation〕 button is click(ed) after processing, Confirm that it is errorless.

↑

Entry of Sales order batch entry †

With the 〔Confirm〕 button, if there is no error in the file which carries out Batch entry, the 〔Entry〕 button will be click(ed) and Batch entry of Order information will be carried out.

An Entry procedure becomes as follows.
①click the 〔Reference〕 button of File name and specify the file which uploads.
②If the Entry button is click(ed), Batch entry processing will start.
③Since a List indication of the Entry result will be given if the 〔Result confirmation〕 button is click(ed) after processing, Confirm that it is errorless.
※When an error exists, Order information used as an error is not Entr(ied). Order information used as an error is Entr(ied).

↑

Result confirmation of Sales order batch entry †

Indicate the result processed with the 〔Confirm〕button and the 〔Entry〕 button by List.

↑

Resuluting output of Sales order batch entry †

Download the contents of List of Result confirmation by All pieces and CSV.