Program PMFM, Fulfillment Project Billing Maintenance, is used to define the fulfillment billing lines as the fulfillment house customer. Fulfillment billing lines are set up by project and project line code. They are assigned billing group codes, and five billing line types can be set up.
* Bin Locations
* Customer Sales Order
* Freight Charges
* Inventory Transactions
* PO Receiving Transactions
Once the billing line is set up, billing transactions are generated from information at the fulfillment house customer level with program PMFB, Fulfillment Project Billing Calculator, and program PMFC, Fulfillment Project Billing Confirmation. Then, billing is completed at the fulfillment house database master level with program PMBM, Project Billing.
Only projects entered for customers in the fulfillment database or for the fulfillment customer can be used in this program.
Entering Customer Sales Order Fulfillment Billing Lines
Entering Bin Location Fulfillment Billing Lines
Entering Freight Charges Fulfillment Billing Lines
Entering Inventory Transactions Fulfillment Billing Lines
Entering PO Receiving Transactions Fulfillment Billing Lines
Entering Sales Leads Fulfillment Billing Lines
1. Enter the billing line number. If you leave this field blank, when you commit, the program will assign a line number
2. Enter a description for the billing line.
3. Enter the billing line group code. Billing line group codes are set up in program PMBC, Maintain Project Billing Calendar, and are used to determine the collection dates and periods for a billing line.
4. Enter the project number for which this billing line will generate billing transactions.
5. Enter the project line code for which this billing line will generate billing transactions. The project line code should be a Labor/Resource type project line code.
6. In the Proj. Key field, enter the resource code from program PMRE, Project Resource Entry, for this billing line.
7. Enter the first billing date in the range of billing dates for this billing line. This is the first date that this billing line becomes effective.
8. Enter the last billing date in the range of billing dates for this billing line.
9. Select the Customer Sales Order type billing line.
10. Select the source for the billing line. Detail must be entered in the right block no matter what source is selected. There are three choices for billing line source:
* Event: A billing transaction is created for each sales order.
* Count: If the detail frequency is defined as Order, one billing transaction is created for each order. If the detail frequency is defined as Line, one billing transaction is created for each sales order line.
* Value: If the status is defined as ‘O - Complete', add the quantity ordered. If the status is anything else, add the quantity shipped.
11. Set the collection frequency. This indicates how often billing transactions can be created for the billing line. Choices are:
* On Demand: billing transactions are counted on demand with program PMFB, Fulfillment Project Billing Calculator.
* Event Driven: billing transactions are counted when the status of the sales order is changed to the status indicated in the Customer Sales Order Detail block.
12. Enter the Threshold count. This is the number of events that can occur before billing transactions can be created for the billing line.
13. Enter the Threshold value. This is the value that must be reached before billing transactions can be created for the billing line.
14. Press [Commit], and move to the Customer Sales Order Detail block to enter detail information. Multiple detail records can be entered for a billing line.
15. Set the Type pop-list to the desired setting. This pop-list indicates the type of transaction that will be counted for billing with this billing line. Choices are:
* Any: all sales orders transactions will be counted.
* Invoice: only invoices created in program ARIE, One Step Invoice Entry, will be counted.
* Order: only sales orders created in program OEOE, Sales Order Entry Maintenance, will be counted.
* Credit Memo: only credit memos created in program ARIE, One Step Invoice Entry, will be counted.
* Credit Note: only credit notes created in program ARIE, One Step Invoice Entry, will be counted.
* Debit Memo: only debit memos created in program ARIE, One Step Invoice Entry, will be counted.
* Debit Note: only debit notes created in program ARIE, One Step Invoice Entry, will be counted.
16. Set the Freq pop-list to the desired setting. This pop-list indicates whether counts will be based on sales orders or sales order lines.
* When the Source pop-list is set to Count, the setting of the Freq pop-list determined how the billing transactions will be created.
* If the Freq pop-list is set to Order, one billing transaction is created for each order.
* If the Freq pop-list is set to Line, one billing transaction is created for each sales order line.
17. In the Status pop-list, select the sales order status for which counts will be made. Choices are as follows:
* Abandoned
* Being Posted to AR
* Cancelled
* Complete
* Confirmed-Comp
* Confirmed-Inc
* Incomplete
* Invoiced
* Lost
* Quotation
* Rollout Template
* Won
18. If the billing line is based on a range of sales order numbers, enter the range in the Order No From and To fields.
19. If the billing line is based on a specific sales reason code, enter the sales reason code in the CRDR field.
20. If the billing line is based on a specific sales location, enter the sales location in the Loc. field.
21. Set the Case pop-list to the desired setting. Choices are:
* Full: billing transactions are created only when the sales order line is a full case, according to the case quantity for the item in program ICPM, Inventory Planning Data Maintenance.
* Split: billing transactions are created only when the sales order line is a partial case, according to the case quantity for the item in program ICPM, Inventory Planning Data Maintenance.
* Either: billing transactions are created when the sales order line is a partial case or a full case, according to the case quantity for the item in program ICPM, Inventory Planning Data Maintenance.
22. If the billing line is based on the freight vendor on the sales order, enter the vendor number in the Frt Vendor field.
23. If the billing line is based on the product group of the items entered on the sales order lines, enter the product group in the Prod Grp field.
24. If you entered a product group, set the pop-list to the right of the Prod Grp field to the desired setting.
* If the Freq is set to Order, the order will be counted as follows according to this pop-list setting:
* Count if ALL lines: the order will be counted if all sales order line items are assigned to the product group entered in the Prod Grp field.
* Count if ANY lines: the order will be counted if any of the sales order line items are assigned to the product group entered in the Prod Grp field.
* Count if NO lines: the order will be counted if none of the sales order lines items are assigned to the product group entered in the Prod Grp field.
* If the Freq is set to Line, the sales order line will be counted as follows according to this pop-list setting:
* Count if ALL lines: the sales order line will be counted if the line item is assigned to the product group entered in the Prod Grp field.
* Count if ANY lines: the sales order line will be counted if the line item is assigned to the product group entered in the Prod Grp field.
* Count if NO lines: the sales order line will be counted if the sales order line is not assigned to the product group entered in the Prod Grp field.
25. Set the Bill Back Orders? flag to the desired setting.
* If this flag is set to on, all orders are considered in the calculation, regardless of the suffix on the sales order.
* If this flag is set to off, only orders with a suffix of 0 are considered in the billing calculation.
26. Press [Commit]. Repeat steps 15 through 25 until all desired detail information has been entered for the billing line.
1. Enter the billing line number. If you leave this field blank, when you commit, the program will assign a line number
2. Enter a description for the billing line.
3. Enter the billing line group code. Billing line group codes are set up in program PMBC, Maintain Project Billing Calendar, and are used to determine the collection dates and periods for a billing line.
4. Enter the project number for which this billing line will generate billing transactions.
5. Enter the project line code for which this billing line will generate billing transactions. The project line code should be a Labor/Resource type project line code.
6. In the Proj. Key field, enter the resource code from program PMRE, Project Resource Entry, for this billing line.
7. Enter the first billing date in the range of billing dates for this billing line. This is the first date that this billing line becomes effective.
8. Enter the last billing date in the range of billing dates for this billing line.
9. Select the Bin Locations type billing line.
10. Select the source for the billing line. Detail must be entered in the right block no matter what source is selected. There are three choices for billing line source:
* Event: Counts are based on the number of location records in the location master.
* Count: Counts are based on the number of locations with inventory in them and the setting of the Bin Type field in the Bin Locations Details section.
* Value: Counts are based on the number of locations with inventory in them and the setting of the Bin Type field in the Bin Locations Details section.
11. Set the collection frequency to On Demand. Bin location billings must be calculated using program PMFB, Fulfillment Project Billing Calculator.
* On Demand: billing transactions are counted on demand with program PMFB, Fulfillment Project Billing Calculator.
12. Enter the Threshold count. This is the number of events that can occur before billing transactions can be created for the billing line.
13. Enter the Threshold value. This is the value that must be reached before billing transactions can be created for the billing line.
14. Press [Commit], and move to the Bin Locations Detail block to enter detail information. Multiple detail records can be entered for a billing line.
15. In the Unit field, enter the manufacturing enterprise in which the bin locations that are being counted exist.
16. In the Plant field, enter the plant in which the bin locations that are being counted exist.
17. In the Bin Type field, select the type of transaction that will be counted. Choices are:
* Average Daily: For each day in the collection range, calculate the number of bins in the entered range of bins that had a quantity on hand. Sum the counts and divide by the number of days in the collection range.
* Defined: Count the number of location records in the location master for the entered range of bin locations.
* Maximum: For each day in the collection range, calculate the number of bins in the entered range of bins that had a quantity on hand. Select the highest count.
* In Use: Count the number of location records in the range given that have a non-zero quantity as of the last day of the billing period.
18. In the Start Area and Bin fields, enter the first stock area and bin location in the range that will be used to calculate billing transactions.
* You can leave the Bin fields blank to have all bins in a stock area included in the count.
* You can leave the Area and Bin fields blank to have all the stock areas and bin locations included in the count.
19. In the End Area and Bin fields, enter the last stock area and bin location in the range that will be used to calculate billing transactions.
* You can leave the Bin fields blank to have all bins in a stock area included in the count.
* You can leave the Area and Bin fields blank to have all the stock areas and bin locations included in the count.
20. If the billing transactions should only be created for locations with a specific location group code, enter the location group code in the Loc Group Code field.
* Location groups codes are user-defined and assigned to locations in program ILMM, Location Master Maintenance.
21. Press [Commit]. Repeat steps 15 through 20 until all desired Bin Locations Detail records have been entered for the billing line.
1. Enter the billing line number. If you leave this field blank, when you commit, the program will assign a line number
2. Enter a description for the billing line.
3. Enter the billing line group code. Billing line group codes are set up in program PMBC, Maintain Project Billing Calendar, and are used to determine the collection dates and periods for a billing line.
4. Enter the project number for which this billing line will generate billing transactions.
5. Enter the project line code for which this billing line will generate billing transactions. The project line code should be a Labor/Resource type project line code.
6. In the Proj. Key field, enter the resource code from program PMRE, Project Resource Entry, for this billing line.
7. Enter the first billing date in the range of billing dates for this billing line. This is the first date that this billing line becomes effective.
8. Enter the last billing date in the range of billing dates for this billing line.
9. Select the Freight Charges type billing line.
10. Select the source for the billing line. Detail must be entered in the right block no matter what source is selected. There are three choices for billing line source:
* Event: Counts are based on the number of sales orders.
* Count: Counts are based on the number of sales orders.
* Value: Add the selected value * freight multiplier, round to nearest hundredth. The value type and freight multiplier are entered in the Freight Charges Detail block.
11. Set the collection frequency. This indicates how often billing transactions can be created for the billing line. Choices are:
* On Demand: billing transactions are counted on demand with program PMFB, Fulfillment Project Billing Calculator.
* Event Driven: billing transactions are counted when the order status changes to V - Invoiced.
12. Enter the Threshold count. This is the number of events that can occur before billing transactions can be created for the billing line.
13. Enter the Threshold value. This is the value that must be reached before billing transactions can be created for the billing line.
14. Press [Commit], and move to the Freight Charges Detail block to enter detail information. Multiple detail records can be entered for a billing line.
15. In the Type pop-list, select Charge or Cost. This determines whether the freight value is calculated by the freight charge, or the freight cost.
16. If the billing is determined by vendor, enter the vendor number in the Vendor field.
17. Enter the Multiplier. When the Source pop-list is set to Value, this is the number by which the freight value will be multiplied to determine the billing transaction amount.
18. If the billing is determined by ship via code, enter the ship via code in the Shipvia Cd field.
19. Press [Commit]. Repeat steps 15 through 18 until all desired Freight Charges Detail records have been entered for the billing line.
1. Enter the billing line number. If you leave this field blank, when you commit, the program will assign a line number
2. Enter a description for the billing line.
3. Enter the billing line group code. Billing line group codes are set up in program PMBC, Maintain Project Billing Calendar, and are used to determine the collection dates and periods for a billing line.
4. Enter the project number for which this billing line will generate billing transactions.
5. Enter the project line code for which this billing line will generate billing transactions. The project line code should be a Labor/Resource type project line code.
6. In the Proj. Key field, enter the resource code from program PMRE, Project Resource Entry, for this billing line.
7. Enter the first billing date in the range of billing dates for this billing line. This is the first date that this billing line becomes effective.
8. Enter the last billing date in the range of billing dates for this billing line.
9. Select the Inventory Transactions type billing line.
10. Select the source for the billing line. Detail must be entered in the right block no matter what source is selected. There are three choices for billing line source:
* Event: Counts are based on inserts into the item transaction log.
* Count: Counts are based on inserts into the item transaction log.
* Value: Counts are based on the absolute transaction quantity.
11. Set the collection frequency. This indicates how often billing transactions can be created for the billing line. Choices are:
* On Demand: billing transactions are counted on demand with program PMFB, Fulfillment Project Billing Calculator.
* Event Driven: billing transactions are counted when an entry is made into the item transaction log.
12. Enter the Threshold count. This is the number of events that can occur before billing transactions can be created for the billing line.
13. Enter the Threshold value. This is the value that must be reached before billing transactions can be created for the billing line.
14. Press [Commit], and move to the Inventory Transactions Detail block to enter detail information. Multiple detail records can be entered for a billing line.
15. If billing is determined by product group, enter the product group in the Group field.
16. If the billing is determined by product code, enter the product code in the Code field.
17. If billing is determined by transaction type, enter the inventory transaction type in the Trans Type field.
18. Press [Commit]. Repeat steps 15 through 17 until all desired Inventory Transactions Detail records have been entered for the billing line.
1. Enter the billing line number. If you leave this field blank, when you commit, the program will assign a line number
2. Enter a description for the billing line.
3. Enter the billing line group code. Billing line group codes are set up in program PMBC, Maintain Project Billing Calendar, and are used to determine the collection dates and periods for a billing line.
4. Enter the project number for which this billing line will generate billing transactions.
5. Enter the project line code for which this billing line will generate billing transactions. The project line code should be a Labor/Resource type project line code.
6. In the Proj. Key field, enter the resource code from program PMRE, Project Resource Entry, for this billing line.
7. Enter the first billing date in the range of billing dates for this billing line. This is the first date that this billing line becomes effective.
8. Enter the last billing date in the range of billing dates for this billing line.
9. Select the PO Receiving Transactions type billing line.
10. Select the source for the billing line. Detail must be entered in the right block no matter what source is selected. There are three choices for billing line source:
* Event: A count is added for each receiver.
* Count: Counts are based on the Type setting in the PO Receiving Transactions Detail block. If the Type is set to Receiver, a count is added for each receiver. If Type is set to Line, a count is added for each receiver line.
* Value: Counts are based on the total receipt quantity in stock units for each line.
11. Set the collection frequency. This indicates how often billing transactions can be created for the billing line. Choices are:
* On Demand: billing transactions are counted on demand with program PMFB, Fulfillment Project Billing Calculator.
* Event Driven: billing transactions are counted for each receiver.
12. Enter the Threshold count. This is the number of events that can occur before billing transactions can be created for the billing line.
13. Enter the Threshold value. This is the value that must be reached before billing transactions can be created for the billing line.
14. Press [Commit], and move to the PO Receiving Detail block to enter detail information. Multiple detail records can be entered for a billing line.
15. Set the Type pop-list to Line or Receiver. This is used with the billing source Count.
* If the Type is set to Receiver, a count is added for each receiver.
* If Type is set to Line, a count is added for each receiver line.
16. Press [Commit].
1. Enter the billing line number. If you leave this field blank, when you commit, the program will assign a line number
2. Enter a description for the billing line.
3. Enter the billing line group code. Billing line group codes are set up in program PMBC, Maintain Project Billing Calendar, and are used to determine the collection dates and periods for a billing line.
4. Enter the project number for which this billing line will generate billing transactions.
* This is the project number to which the sales lead transactions will be compared to determine if they are to be collected.
5. Enter the project line code for which this billing line will generate billing transactions. The project line code should be a Labor/Resource type project line code.
6. In the Proj. Key field, enter the resource code from program PMRE, Project Resource Entry, for this billing line.
7. Enter the first billing date in the range of billing dates for this billing line. This is the first date that this billing line becomes effective.
8. Enter the last billing date in the range of billing dates for this billing line.
9. Select the Sales Leads type billing line.
10. Select the source for the billing line. Detail must be entered in the right block no matter what source is selected. There are three choices for billing line source:
* Event: A count is added for each sales lead.
* Count: Counts are based on the setting of the Match Rule pop-list in the Sales Leads Transactions Detail block. If the Match Rule is set to Match on Project Number, a count is added for each sales lead assigned to project that matches the project entered in the Proj No field. If the Match Rule is set to Null Project Number or No Match, a count is added for each sales lead assigned to project that does not match the project entered in the Proj No field.
* Value: A count is added for each sales lead.
11. Set the collection frequency. This indicates how often billing transactions can be created for the billing line. Choices are:
* On Demand: billing transactions are counted on demand with program PMFB, Fulfillment Project Billing Calculator.
* Event Driven: billing transactions are counted for each sales lead entered or imported.
12. Enter the Threshold count. This is the number of events that can occur before billing transactions can be created for the billing line.
13. Enter the Threshold value. This is the value that must be reached before billing transactions can be created for the billing line.
14. Press [Commit], and move to the Sales Leads Detail block to enter detail information.
15. Set the Match Rule pop-list to Match on Project Number or Null Project Number or No Match. This is used with the billing source Count.
* If the Match Rule is set to Match on Project Number, a count is added for each sales lead assigned to project that matches the project entered in the Proj No field.
* If the Match Rule is set to Null Project Number or No Match, a count is added for each sales lead assigned to project that does not match the project entered in the Proj No field.
16. Press [Commit].
View all billing transactions that have been generated for this billing line. Information includes the status, status date, data count, event count, data value, collection start date, and collection end date.
View the billing log for the billing line. Information includes the collection date and the log text.