| Description |
*Background:*
# A delivery is made to a customer on a Basis sales contract
# An invocie is not created since price is not established
# user wants visibility to all the unpriced basis contracts with deliveries
# The next step would be to price them
*Add two menu items to Contracts called:*
Unpriced delivered Sales contracts
# Get a report of all scale tickets
# That have been delivered against basis contracts
# and their related invoice (left outer becasue it may not be invoiced yet and these are the items we are looking for)
Unpriced delivered purchase contracts
# Get a report of all scale tickets
# That have been delivered against basis contracts
# and their related voucher (left outer becasue it may not be invoiced yet and these are the items we are looking for)
Should show the following fields:
|Field| | |
|Customer\Vendor| | |
|Commodity| | |
|Location| | |
|Scale ticket number|Drillable| |
|Scale ticket date| | |
|Load number| | |
|Scale Qty| |Show the total ticket qty|
|Basis Qty| |Some may have been applied to another priced contract. This is qty that needs priced|
|Load number|Drillable|Load number from the ticket|
|Contract/Sequence|Drillable| |
|Customer Ref.| |From contract screen|
|Sequence Balance| | |
|{color:#ff0000}Invoice number/ voucher number{color}|{color:#ff0000}drillable{color}|{color:#ff0000}outer join in case has not been invoiced - This will be more for historical purposes so you can see invoice after it is priced and invoice generated{color}|
|{color:#ff0000}Futures Price {color}| |{color:#ff0000}Futures price for the invoice (this will have to come from the contract since the invoice doesn't have it broken out){color}|
|{color:#ff0000}Basis{color}| |{color:#ff0000}Basis price for the invoice (this will have to come from the contract since the invoice doesn't have it broken out){color}|
| | | |
!pastedImage_d106783_0.png|height=521,width=817!
|