Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

There are a couple of ways on how Other Charges are added to either Inventory Receipt or Bill Voucher based on different scenarios. Here are items we will use in all of the scenarios.

This is the item.

Image RemovedImage Added

Image RemovedImage Added

This is the Other Charge item.

Image RemovedImage Added

These are accounts setup for the Other Charge item.

Image Added

 Image Removed

Expand
titleScenario 1: Should not be allowed since Price = checked and Accrue = checked for receipt vendor is same as cost did not occur.

This scenario should not be allowed since Price = checked and Accrue = checked for receipt vendor is same as cost did not occur.

  1. Create Inventory Receipt. Select an item.
    Image RemovedImage Added
  2. Go to Charges & Invoice tab and select an other charge item. Setup the other charge item to have:
    1. Inventory Cost is unchecked
    2. Accrue checkbox is checked and vendor selected is the same vendor where the item will be coming from.
    3. Price is checked
  3. Save or click Recap or Receive toolbar button. The Price field will show a red border. Hover on that field and it will tell you that:
    The <Other Charge> is both a payable and deductible to the bill Voucher of the same vendor. Please correct the Price checkbox.
    Image Added
Expand
titleScenario 2: Other Charge added as Other Expense to the item purchased and be payable to the Vendor where item is purchased.

The following will detail Other Charge added as Other Expense to the item purchased and be payable to the Vendor where item is purchased.

  1. Create Inventory Receipt. Select an item.
    Image RemovedImage Added
  2. Go to Charges & Invoice tab and select an other charge item. Setup the other charge item to have:
    1. Inventory Cost is unchecked
    2. Accrue checkbox is checked and vendor selected is the same vendor where the item will be coming from.
    3. Price Down is unchecked
      Image Removed
  3. Posting Inventory Receipt with this scenario will only record the item purchased.
    Image Removed
  4. Post the Inventory Receipt and process it to Bill by clicking the Bill toolbar button.
    Image Removed
    Notice also that in the Detail tab, there is the Total Charges shown. That same amount is the total Charges added in the Charges & Invoice tab.
  5. This is the Bill created. Notice that the Other Charge is added as a separate line to record the Other Charge incurred.
    Image Removed
    1. Image Added
  6. Click Post Preview. GL Entries should look like this.
    Image Added
  7. Post Inventory receipt. Go back to details tab, other charge should be included in the total of the receipt.
    Image Added
  8. Click Voucher Button to create voucher. This message will be shown.
    Image Added
  9. Click Yes. Voucher will be created.
    Image Added
  10. Click post preview tab, this voucher Posting this Bill will record the Other Charges incurred in bringing the item to the company location. The amount of the Other Charge plus the amount credited to AP Clearing account from the Inventory Receipt is summed up and is passed to Accounts Payable.
    Image RemovedImage Added
  11. Click Post button to post the Billvoucher.Image Removed
Expand
titleScenario 3: Other Charge added to the Item Cost and is payable to the Vendor where item is purchased.

The following will detail Other Charge added to the Item Cost and is payable to the Vendor where item is purchased.

  1. Create Inventory Receipt. Select an item.
    Image RemovedImage Added
  2. Go to Charges & Invoice tab and select an other charge item. Setup the other charge item to have:
    1. Inventory Cost is checked
    2. Accrue checkbox is checked and vendor selected is the same vendor where the item will be coming from.
    3. Price is unchecked
      Image RemovedImage Added
  3. Click Post Preview Tab, posting Posting Inventory Receipt with this scenario will add the Other Charge to the item cost. Notice from the Item cost of 100.00, it went up to 110.00, 10.00 being the Other Charge added to the item cost.
    Image Removed

  4. Post the Inventory Receipt and process it to Bill Voucher by clicking the Bill Voucher toolbar button.
    Image Removed
    Notice also that in the Detail tab, there is the Total Charges shown. That same amount is the total Charges added in the Charges & Invoice tab.Image Added
  5. Click Voucher Button to create voucher. This message will be shown.
    Image Added
  6. This is the Bill Voucher created. Notice that the Other Charge is added as a separate line to record the Other Charge incurred.
    Image RemovedImage Added
  7. Posting this Bill voicher will record the Other Charges incurred in bringing the item to the company location. The amount of the Other Charge plus the amount credited to AP Clearing account from the Inventory Receipt is summed up and is passed to Accounts Payable.
    Image RemovedImage Added
  8. Post the Billvoucher..
    Image RemovedTo further explain what happens to the Item cost since Other Charge is added to the Item Cost, open the Item record from the Bill Voucher screen. The Last Cost as well as the Average Cost is updated with the new cost, computed as:
    .
  9. Example: Item Cost = Inventory @ 110.00 / Qty received and Billed Vouchered of 10
    = 110.00/10
    = 11.00Image Removed
Expand
titleScenario 4: Other Charge recorded as other charge and is payable to another vendor (not the vendor where the item is purchased).

The following will detail Other Charge recorded as other charge and is payable to another vendor (not the vendor where the item is purchased).

  1. Create Inventory Receipt. Select an item.
    Image RemovedImage Added
  2. Go to Charges & Invoice tab and select an other charge item. Setup the other charge item to have:
    1. Inventory Cost is unchecked
    2. Accrue checkbox is checked and vendor selected is another vendor (third-party vendor).
    3. Price is checked
      Image RemovedImage Added
  3. Click Post Preview Tab. GL entries should look like this.

    Image AddedPosting Inventory Receipt with this scenario will only record the item purchased.
    Image Removed
  4. Post the Inventory Receipt and process it to Bill voucher by clicking the Bill toolbar Voucher button.
    Image Removed
    Notice also that in the Detail tab, there is the Total Charges shown. That same amount is the total Charges added in the Charges & Invoice tab.Image Added
  5. This is the Bill Vocher created. Notice that only the item purchased is added in the grid. This is because the Other Charge is charged by a third party vendor.
    Image Removed
  6. Posting this Bill will zero out the AP Clearing account and pass that same amount to Accounts Payable for the amount of the Item cost only.
    Image Removed
  7. Post the Bill.
    Image Removed
  8. Image Added
  9. Post the Voucher.
  10. To record the Other Charge, create a new Bill Voucher and select the third-party vendor. This is the Vendor selected in the Inventory Receipt > Charges and Invoice tab > Vendor (field next to Accrue checkbox).
    Image Removed
    The Add Inventory Receipt screen will be opened.
    Image RemovedImage Added
  11. Go to Purcahasing AP>Vouchers>New. Select Voucher as type then enter third party vendor in vendor field.
    Image Added
  12. Click Add Payables. Add payable screen will open. Select the correspoding receipt then click Add button.
    Image AddedFind for the Inventory Receipt transaction and select it. Then click Add toolbar button.
    Image Removed
  13. The Other Charge is added in the Item grid. On this bill Voucher is where the Other Charge is recorded.
    Image RemovedImage Added
  14. Posting this Bill Voucher will record the Other Charge payable to another vendor (third-party vendor).
    Image RemovedImage Added
  15. Post the BillVoucher.Image Removed
Expand
titleScenario 5: Should not be allowed as this is not possible. If cost is passed on to receipt vendor, it cannot be added to inventory cost.

This scenario should not be allowed as this is not possible. If cost is passed on to receipt vendor, it cannot be added to inventory cost.

  1. Create Inventory Receipt. Select an item.
    Image RemovedImage Added
  2. Go to Charges & Invoice tab and select an other charge item. Setup the other charge item to have:
    1. Inventory Cost is checked
    2. Accrue checkbox is checked and vendor selected is another vendor (third-party vendor).
    3. Price is checked
  3. Save or click Recap or Receive toolbar button. The Price field will show a red border. Hover on that field and it will tell you that:
    <Other Charge> is shouldered by the receipt vendor and can't be added to the item cost. Please correct Price checkbox.
    Image RemovedImage Added
Expand
titleScenario 6: Other Charge recorded as other charge and is payable to another vendor (not the vendor where the item is purchased).

The following will detail Other Charge recorded as other charge and is payable to another vendor (not the vendor where the item is purchased).

  1. Create Inventory Receipt. Select an item.
    Image RemovedImage Added
  2. Go to Charges & Invoice tab and select an other charge item. Setup the other charge item to have:
    1. Inventory Cost is checked
    2. Accrue checkbox is checked and vendor selected is another vendor (third-party vendor).
    3. Price is unchecked
      Image RemovedImage Added
  3. Posting Inventory Receipt with this scenario will add the Other Charge to the item cost. Notice from the Item cost of 100.00, it went up to 110.00, 10.00 being the Other Charge added to the item cost.
    Image RemovedImage Added
  4. Post the Inventory Receipt and process it to Bill Voucher by clicking the Bill toolbar button Voucher Button.
    Image Removed
    Notice also that in the Detail tab, there is the Total Charges shown. That same amount is the total Charges added in the Charges & Invoice tab.Image Added
  5. This is the Bill Voucher created. Notice that only the item purchased is added in the grid. This is because the Other Charge is charged by a third party vendor.
    Image RemovedImage Added
  6. Posting this Bill Voucher will zero out the AP Clearing account and pass that same amount to Accounts Payable for the amount of the Item cost only.
    Image RemovedImage Added
  7. Post the BillVoucher.
    Image Removed
  8. To record the Other Charge, create a new Bill Voucher and select the third-party vendor. This is the Vendor selected in the Inventory Receipt > Charges and Invoice tab > Vendor (field next to Accrue checkbox).
    Image Removed
    The Add Inventory Receipt screen will be opened.
    Image RemovedImage Added
  9. Find for the Inventory Receipt transaction and select it. Then click Add toolbar button.
    Image Removed. Go to Purchasing AP > Vouchers> New. This will open New Voucher screen. Select Voucher as Type then select the third party vendor and enter invoice number. Click Add Payables button.\
    Image Added
  10. The Other Charge is added in the Item grid. On this bill Voucher is where the Other Charge is recorded.
    Image RemovedImage Added
  11. Posting this Bill Voucher will record the Other Charge payable to another vendor (third-party vendor).
    Image RemovedImage Added
  12. Post the BillVoucher.Image Removed
Expand
titleScenario 7: Other Charge recorded as an Other Expense as well as an Other Revenue that will offset each other.

The following will detail Other Charge recorded as an Other Expense as well as an Other Revenue that will offset each other.

  1. Create Inventory Receipt. Select an item.
  2. Go to Charges & Invoice tab and select an other charge item. Setup the other charge item to have:
    1. Inventory Cost is unchecked
    2. Accrue checkbox is unchecked
    3. Price is checked
  3. Posting Inventory Receipt with this scenario will only record the item purchased.
  4. Post the Inventory Receipt and process it to Bill Voucher by clicking the Bill Voucher toolbar button.

    Notice also that in the Detail tab, there is the Total Charges shown. That same amount is the total Charges added in the Charges & Invoice tab.
  5. This is the Bill Voucher created. Notice that in Item grid, the item and the Other Charge is shown but the Other Charge is shown as negative.
    add screenshot here once the bill Voucher is fixed.
  6. Posting this Bill Voucher will record the Other Charge payable to another vendor (third-party vendor).
  7. Post the BillVoucher.
  8. Posting this Bill Voucher will zero out the AP Clearing account and pass that same amount to Accounts Payable for the amount of the Item cost only. The Other Charge is recorded as an Other Expense as well as an Other Revenue that will offset each other.
    Add screenshot here once this is fixed
  9. Post the BillVoucher
    Add screenshot here once this is fixed

...