Grouped Sites
Use PC Grouped Site Maintenance (30.5.1.13) to set up sites that are treated as one site for the purpose of calculating the PC cost. The system considers transactions in all sites within the group as if they all were in one site for the purpose of Periodic Costing.
You can use PC Grouped Site Maintenance (30.5.1.13) to delete sites from grouped sites so that the site cost can be calculated independently.
Important: Once you delete a site from grouped sites, you must rerun the PC calculation. When you remove a site from a group, Grouped Site Maintenance warns you to rerun the calculation.
When a unit cost adjustment was made to the grouped sites, then you remove a site from the group, the unit cost adjustment is still effective for this site. You should manually adjust if necessary.
For grouped sites, note the following:
• All receipts in grouped sites are in the unit cost calculation before issues are processed.
• Grouped sites cannot be set up as cross entities; that is, you cannot add sites from other entities to a grouped site in PC Grouped Site Maintenance (30.5.1.13).
• You cannot post to discrepancies for WO closes when there is receipt quantity in other grouped sites.
• The system processes summarized transactions for grouped sites.
• When the unit cost calculation results in 0 (zero) or negative, the system resets the unit cost of the group to that of the latest period with costs. It posts cost deviations to discrepancy when there is no order receipt quantity or revalues costs when there is order quantity and logs exceptions.
• When there is no order receipt quantity, and therefore, no unit cost for the period, the system sets the unit cost of the group to that of the latest period with cost and logs exception.
• When there is no previous period with cost, the system logs the exception.
• FIFO inventory stacks are at the grouped site level. You can only add and remove sites in a group when previous PC cost exists.
• The system reverses the PC total adjustment (PCTOT-AD) when there is no receipt quantity in any site in the group. The system posts to discrepancies when there is no order receipt quantity in any site in the group.
• You can only add and remove sites in a group when previous PC cost exists.
• For negative PC total cost adjustments (PCTOT-AD), the system considers total TL and LL cost of grouped sites.
• PC calculation first processes the grouped site with most transfer out quantity.
PC Grouped Site Maintenance (30.5.1.13)
Transfer or Perform DRP Between Grouped Sites
Periodic Costing calculation handles transfers between sites that are in the same group as local transfers. The Periodic Costing unit cost is no longer impacted by them. Previously, intersite transfers and DRP were processed in DRP receipt calculations before the unit cost calculation. Now, all local transfers are processed after unit cost calculations.
Apply PC Unit Cost Adjustment to Grouped Sites
You can use PC Unit Cost Adjustment (30.5.5.1) for a site in a group to adjust a period cost. The system creates the PCCST-AD transaction for every site in the group and applies the PC calculation to the new unit cost to all sites in the group. This functionality is also available when you use PC Unit Cost Adjustment Upload (30.5.5.4).
Account Balancing for Grouped Sites
Periodic Costing performs account balancing across all sites in the group.
Example: For an account balance for a grouped site, you have site1 and site2 grouped. The following data exists for the sites:
Grouped Site Data: | Account | Receipt Data | | |
Site 1 | InvAcc1 | RCT-PO 10 * $1 | | |
Site 2 | InvAcc2 | RCT-PO 10 * $1 | | |
Result of PC calculation: |
| Account | Unconsumed Qty | Unit Cost | Total Cost |
site1 loc1 | InvAcc1 | 10 | 1.5 | 15 |
site1 loc2 | InvAcc2 | 10 | 1.0 | 10 |
Account balance transactions: |
Site 1: PCACCBAL PC Amount = 10*25/20 - 15 = -2.50 |
| Dr InvAcc1 -2.50 | | | |
| Cr Offset -2.50 | | | |
Site 2: PCACCBAL PC Amount = 10*25/20 - 10 = 2.50 |
| Dr InvAcc2 2.50 | | | |
| Cr Offset 2.50 | | | |