sean_gilbert
Well Known Member
I'm looking for ideas as to any modules that could help me satisfy these requirements: (I've been looing at Contract & service billing but still see somes gaps)
-Create Customer contract
- Enter a billing line for the equipment rental (line billing period starting on Feb 1 ending on June 30) @ 2800/month (month = 28days)
- Enter a second equipment for rental starting on (line billing period starting Feb 15 ending on July 31) @ 1400/month (month = 28 days)
- Enter a Transportation unit price/ea to bill (must be calculated based on quantity purchased from supplier on a PO)
- Enter an Installation unit price/hr to bill (must be calculated based on quantity purchased from supplier on a PO)
-Billing for contract starting on actual start date every 28days.
- Billing UBE will run nighlty but should only invoice the above billing lines once every 28days
- First invoice on Feb28 (at 28days) need to prorate the second equipment rental for Feb28 (1400$/28days in month*13days usage)=650$ by prorating the first 28day period subsequent invoices can fall into the same cycle as the first rental line.
- Transportation and Installation lines will be accumulating through POs from Feb1 but none should be billed until Feb28 the first billing day of the contract
- Billing workfile (ie Billing Amounts) must be modifiable for all billing lines types used above.
Gaps with JDE
-Bill contract every 28days from start date
-All lines must fall into the 28day cycle (services from POs CANNOT be billed as they occur)
-Only certain billing line types are modifiable in Billing Workfile.
I'm looking for ideas for workarounds or maybe I missed some existing functionality.
Thanks Sean
-Create Customer contract
- Enter a billing line for the equipment rental (line billing period starting on Feb 1 ending on June 30) @ 2800/month (month = 28days)
- Enter a second equipment for rental starting on (line billing period starting Feb 15 ending on July 31) @ 1400/month (month = 28 days)
- Enter a Transportation unit price/ea to bill (must be calculated based on quantity purchased from supplier on a PO)
- Enter an Installation unit price/hr to bill (must be calculated based on quantity purchased from supplier on a PO)
-Billing for contract starting on actual start date every 28days.
- Billing UBE will run nighlty but should only invoice the above billing lines once every 28days
- First invoice on Feb28 (at 28days) need to prorate the second equipment rental for Feb28 (1400$/28days in month*13days usage)=650$ by prorating the first 28day period subsequent invoices can fall into the same cycle as the first rental line.
- Transportation and Installation lines will be accumulating through POs from Feb1 but none should be billed until Feb28 the first billing day of the contract
- Billing workfile (ie Billing Amounts) must be modifiable for all billing lines types used above.
Gaps with JDE
-Bill contract every 28days from start date
-All lines must fall into the 28day cycle (services from POs CANNOT be billed as they occur)
-Only certain billing line types are modifiable in Billing Workfile.
I'm looking for ideas for workarounds or maybe I missed some existing functionality.
Thanks Sean