Venture

• Bug fixed where if the “Prepend Vendor Code” checkbox wasn’t checked for a price update, the price update wouldn’t commit.

• Added new A/P invoice type “S”, which is a Regular-Prepaid type invoice, that is a regular invoice that will be paid by prepaid invoice credit.

• Added price and cost source information to item preview in client

Take note that updating to Venture 4.4.1 will be a required update. You won’t be allowed to login to Venture on an older client once 4.4.1 is released.

With the release of 4.4.1 we are switching from the current “contract” price system to a “override” system that is more flexible.  Where before you could only assign an override to a particular item, the new system supports these types of overrides, listed in the hierarchy in which they are applied:

ITEM:  Override tied to item code
VN/DG: Override tied to vendor code/sales discount group
VN: Override tied to vendor code
DG: Override tied to sales discount group
VN/PG: Override tied to vendor code/product group
PG: Override tied to product group

You can now also override cost as well as price, and you can either have a straight price or cost, or a multiplier that can operate on any of these three price/costs:

LIST: For P21 users, this is the same as COL1 price
STD COST: For P21 users, this is the same as STD COST
P/O COST: For P21 users, this is the same as LIST PRICE

Currently, there isn’t override price maintenance in the Venture client, it will be coming soon, but if you need to have an override entered in the system let Tony know and he’ll manually add it to the database. KSC overrides will be synced to P21 on a regular basis, so if you have entered a new override in P21, it will eventually show up in Venture.

Other changes to Venture:

• New advanced order search under the “Order Status” menu: “Needs Tax Schedule”. Will show all open orders that don’t have a tax schedule assigned to them.
• Bugfix: If you got into vendor maintenance from the main “Add/Edit Vendor Record” and typed and existing vendor code into that field, it wouldn’t pull up the data for that vendor. That’s fixed.
• Change: If the company wide settings “Count Sheet Max %” and “Count Sheet Max $” are set to zero or are blank, that tells the system to skip that check.
• New A/P report: “P/O Recon”. For report range shows open P/O’s line status for quantity ordered, quantity received, quantity reconciled, quantity balance due-in and condsider complete, which if any material receipt set that flag, it shows true. This report is intended to aid in closing old P/O’s
• When entering a transfer, you now have the ability to enter transfer header fields shipping instructions, freight carrier and freight tracking #. You can also update those fields through editing the transfer.

Here are the changes:

• Matrix pricing removed, replaced with pricing schedules.  Current matrix pricing converted over to schedules.
• Quantity breaks removed from item master and sales order processing.
• Order notes now have first 20 characters of note text in subject.
• Tax->Jurisdiction map screen in Venture no longer tries to lookup all the maps when screen is first loaded.
• P/O Cost field added to item master.  This gets populated from price sheet updates and is the cost used as “Expected Cost” when creating P/O’s.

Changes:

• Adding and editing has been separated into two different permissions.  Everyone who had add/edit permissions has been given edit permissions.  If you need to be able to add vendors, Tonja or Tony can set that up.
• Mousing over line-items comments in the order preview in order lookup now shows you the full text of the lookup.
• Canceling orders now requires a “cancellation reason”.  Those are in a drop down menu displayed at the time the order is cancelled.  They should be pretty self-explanatory
• Notes on orders can now have a follow up date. Setting a follow up date on a note on an order will cause the number of notes to show red in order lookup if the current date is equal to or after the follow up date. Notes that have met their follow up date will show in red when you go to view the notes. The follow up date can be cleared on the note by either right clicking on it in the first notes screen or clearing it out under the notes details.
• Transfers and P/O’s now each have their own entry screen in Venture.  Both are accessed under “Vendors” in the main menu.
• Venture now has transfer backorders.  More on this below.
• Allocating items to sales orders has changed.  You can also allocate to transfer backorders.  More on this below.

Transfer Backorders:

Transfer backorders are a request for material to be transferred from one branch to another, and the material must be allocated in the source branch before the transfer will be created.  This differs from a standard transfer you may be used to in Venture in that the material isn’t automatically allocated.

There are two ways to create a transfer backorder, one is by selecting a different source warehouse than the ship warehouse during sales order processing and setting the fulfillment flag to “Warehouse”.  This will automatically create the transfer backorder, and if you edit the sales order line, the requirements in the source warehouse are automatically updated.

The other way to explicitly create a transfer backorder.  The way you do this is to start a transfer, which is under Vendors->Create Stock Transfer.  You’ll be asked to select the source and the destination warehouse:

After selecting the warehouse, you enter the items on the transfer.  There are two quantity fields, quantity ordered and quantity shipped.  If you leave quantity shipped set to zero, then the item creates a transfer backorder:

You won’t see the item show up on the transfer, and you won’t get a system transfer number, but the item will be added to the transfer pool.  You can see items in the transfer pool from the main lookup, a “*” search shows you all transfer backorders that haven’t been allocated and an “=” search shows you all transfer backorders in the source warehouse.  An example would be “=11″, which would show you all transfer backorders sourced from Omaha.

If you want to create an actual transfer, then set the quantity shipped in the transfer processing to a positive value:

Once you accept the item it will create a transfer and you will see the item on transfer and get a system transfer number:

Usually, you will set quantity shipped the same as quantity ordered, but you can set quantity shipped to less than quantity ordered if you want to put some of the item on a transfer backorder.

The only way an item gets allocated in the source warehouse without having to be allocated in a separate step is if you set the item as shippable on a transfer.Items on transfer backorders can be cancelled, they’ll show up in the lookup without a sales order number, and you simply right click them and there’s a menu option to delete them.

Before an item on a transfer backorder can be put on a transfer, it has to be allocated.  This is accessed under Items->Allocate Items - Transfers in the main menu.  The first step asks you which warehouse you’re allocating from and there’s a couple other optional filters:

After selecting your warehouse and optional filters, you will be presented step-by-step screens that show items that have free stock and can be allocated to any transfer backorders out there.  If there is sufficient free stock, the quantity to allocate is filled in with the amount backordered, otherwise you have to manually allocated to the transfers.  Here is an example screen:

Notice that there are 113 free, and only 6 backordered, so the quantity to allocate has been set to 6.  To change the value to allocate, double click on the number.  If you wish to skip allocating the item, just click the “Skip This Item” button, and the next item will be shown.

Once you’ve went through all the items to be allocated, the allocation screen will automatically close.

When you’re ready to create the transfer(s), go to Vendors->Create Automatic Stock Transfers from the main menu, and you will be asked what source warehouse you wish to create transfers from and an expected ship date.  After you click “OK”, Venture will tell you in the console how many transfers were created with how many lines.  If there are multiple destination warehouses, Venture will create a transfer for each destination warehouse in one step.  You can see the transfers created in the P/O lookup.

Sales Order Backorder Allocation:

This works exactly the same as transfer backorder allocation, except instead of allocating items to transfer backorders, they’re being allocated to sales orders.  To relieve backorders on sales order go to Items->Allocate Items - Sales Orders from the main menu.  You will be asked which warehouse to do the allocation for and there’s some optional filters to narrow results if needed.  The allocation screen is exactly the same as for transfer allocation and works the same.  Only items that have free stock and are backordered on a sales order are shown.

• Added item code print flag to customer master.  Now you can select if the customer’s item code prints on invoices, orders and packing slips.
• Fixed bug in A/R lookup where right clicking on the order number -> order lookup was broken.

• In the Accounting module, there is now an Advanced Search.  If you need to look up customer invoices, check it out.
• In the A/R invoice lookup in the Accounting module, if you select several invoices, the preview on the right will give the aggregate total of those invoices.  
• Invoice preview in A/R lookup fixed, there were some fields that were blank and weren’t getting pulled in from the invoice.
• Customer lookup in Accounting module is now the same lookup as the core Venture module with the same right-click options.
• Sales reports have now been broken out into “Sales by Customer” and “Sales by Vendor”, so you can view item sales with either the vendor or customer as the key.
• Canceling a line on a suspended P/O or order will now delete that line from the order and renumber the lines so they’re sequential when the order/PO is processed.
• Price updates now show both the folder name (tied to user) and the original file name in the left-hand pane.
• Manual stock adjustments now require a “reason code”.  The reason codes are in a drop-down menu, so pick the appropriate one if you do manual stock adjustments.

• Module management bugfix: If you try and open a module that is already open, it would break the menu for that module.  Now all instances of that module will just be brought to the top of the window stack.
• Added P/O advanced search.

• Added margin % to item master 

• Modules are now color coded.  Gray: Main, Green: Accounting, Blue: eBay, Brown: Purchasing.
• Modules now show what page you’re on in the toolbar.
• Item master no longer has P&A and item ledger tabs
• Manual price update moved to item warehouse page (access through item lookup right-click)
• Confirm item price update page now shows the folder name that the price update came from.

• Refresh button on item price updates page now also refreshes the reports iframe.
• Added LTL shipping report to Inventory reports.

• Fixed preview in P/O lookup so items are by default expanded.
• Fixed quote lookup to show lock owner and timestamp in results & added clear lock to right-click context menu.

• Bugfix: Lookup on item assembly dialog was broken.
• Bugfix: Fixed preview in order lookup so items are always expanded

• Vendor code is now an editable field in sales order processing.  (Clears Bug # 103)
• Bugfix: Customer statements wouldn’t print.

• Bugfix: Price update service was still referencing “D” item type.  Fixed so you can set default fulfillment flag on client and fixed server code to default to “I” type item.

• Added “Unreconciled Receivings” report to the A/P reports.

• Fixed client problem where user wasn’t given the option to “Assign Stock” to orders in “P” status even though those could have backordered items on them.
• Fixed code on server side to look at both “B” and “P” status orders when relieving backorders
• Fixed client to automatically prefill tax jurisdiction based on shipping zip code

• Added previous/next to notes dialog.
• Accounting dept can now print check details for any payment type.

• In order lookup, “Output Invoice” is now “Output Order”, and the only order status that has that disabled is cancelled orders (Z).  Orders in “I” and “A” status output an invoice, everything else outputs an order overview.