VS Tools Forum

Adding .FLV MIME Type in IIS

Steve Gray — Fri, 11 Jul 2008 14:03:00 GMT

.FLV files are already the best method for publishing video on the web, and are sure to become even better with the new enhancements in Flash 8. When serving .flv files off of a Windows Server 2003 (or any other Windows server I would imagine) requires setting up the MIME type on the server first (it isn't one of the native MIME types on MS servers).

You can figure out easily if your server is configured to support .flv files by posting a .flv file on a server and navigating to the URL of that .flv in a browser. If you see a LONG string of garbage on the screen, your server isn't set up for .FLVs and needs to have the MIME type set up.

Adding .flv MIME type in IIS

1) Select the site to configure in IIS, right click and select "Properties"
2) Under HTTP Headers Tab, select "File Types" under the MIME Map section and select "New Type"
3) Type ".flv" as the associated extension and "video/x-flv" as the content type.
4) Select "OK" and you're ready to fly!

Dynamics GP POP workflow

Steve Gray — Thu, 10 Jul 2008 13:26:00 GMT

This post describes the POP workflow. It's an 'in process' kind of thing - I'll add as I come across it. If anyone has anything to add please send it...

POs are entered via PURCHASING > PURCHASE ORDER ENTRY, into POP10100 and POP10110

RECEIPTS:
There are two types of receipts, SHIPMENT and SHIPMENT/INVOICE

Shipments (when posted) create a line in POP10500 and lines in POP30300 and POP30310

Shipment/Invoices (when posted)...

SOP10100 (SOP_HDR_WORK) Field Definitions

Steve Gray — Mon, 07 Jul 2008 17:49:00 GMT

Table: SOP_HDR_WORK

This file stores all unposted transaction information until it is posted. Records in this file relate to a specific record in the Batch_Headers file.

This table contains the identifying document information for all sales documents entered using the Sales Transaction Entry window (and also the Quotes, Orders, Invoices, and Returns windows). Transaction line item-related records are stored in the SOP_LINE_WORK table. Each record represents a document that has been entered using the Sales Transaction Entry window or created through the transfer process using the Sales Transfer Documents window.

SOP and MC
The following describes changes made as a result of SOP MC. The focus of this discussion is on a non-MC SOP transaction. In SBF, multiple currencies are not supported.

Currency ID-This should be blank for non-MC SOP transactions.
Currency Index-This should be the 'Functional Currency Index' of globals for non-MC SOP transactions.
Rate Type ID-This should be blank for non-MC SOP transactions.
Exchange Table ID-This should be blank for non-MC SOP transactions.
Exchange Rate-This should be blank for non-MC SOP transactions.
Exchange Date-This should be blank for non-MC SOP transactions.
Time-This should be blank for non-MC SOP transactions.
Rate Calculation Method-This should be blank for non-MC SOP transactions.
"Originating" values-The originating currency values (typically in the format "Originating ") are the primary currency values used for a SOP transaction. The corresponding functional currency values (typically in the format "") are calculated from the corresponding originating currency value. For a non-MC SOP transaction, the originating and functional currency values will be the same. Leaving either the originating currency value or the functional currency value blank for a non-MC SOP transaction is not allowed. If the value is not being used, both the originating and functional currency values should be blank.

Optional:
Tax Date - Required for VAT.
Denomination Exchange Rate - Required for Euro Triangulation.
MC Transaction State - Required for Euro.

Display Name Sales Transaction Work
O/S Name SOP10100

Field descriptions: (Required fields appear in bold and are underlined)

SOP Type: Values store in the Data Base for SOP Type are as follows:

1 = Quote
2 = Order
3 = Invoice
4 = Return
5 = Back Order
6 = Fulfillment Order (In SBF, this value is not available.)

Below are the Visual Positions of the elements in SOP Type DDL when Advanced Distribution is registered. Use global function SOPTypeToInt() to deference the visual position in the SOP Type DDL to the data base value. Use global function IntToSOPType() to cast the data base value into a SOP Type DDL. In SBF, the Fulfillment Order is not available but is still a good practice to use the functions.

1 = Quote
2 = Order
3 = Fulfillment Order (In SBF, this value is not available.)
4 = Invoice
5 = Return
6 = Back Order (In SBF, this value is not available.)

SOP Number: The number of the document. This field, along with the Document Type, makes a SOP document unique. (The document should not exist in SOP history).

Original Type: Blank if this is the original document.
1 = Quote
2 = Order
3 = Invoice
4 = Return
5 = Back Order (In SBF, this value is not available.)
6 = Fulfillment Order (In SBF, this value is not available.)

Original Number: If the document was created by a transfer, this is the document number from which the document originated. Blank if this is the original document.

Document ID: Indicates attributes of a transaction. Also know as type ID.
This ID should exist in the SOP_ID_SETP file. In SBF, this field is set to a value of STANDARD. This field is not exposed in the SBF user interface but can be changed through the constant SBM_SOP_DOCTYPEID.

Document Date: The date associated with this transaction.

GL Posting Date: Date that will be assigned as the GL Post Date for all transactions in the batch if Posting Setup is set to post by batch date.

Quote Date: The date of the Quote document. Required for Quote documents only.

Quote Expiration Date: The User Date of the quote plus the Days to Expire for that Type ID. In SBF, Days to Expire is always set to a value of 0.

Order Date: The date the order was placed. This field is for user reference only.

Invoice Date: The date of the Invoice document. Required for Invoice documents only.

Back Order Date: The date of the backorder document. Required for Back Order documents only.

Return Date: The date the Return document type. Required for Return documents only.

Requested Ship Date: Date the items should be shipped. Defaults with the Document Date on Invoice Entry.

Fulfillment Date: The date the last of the line items for the document were fulfilled.

Actual Ship Date: This is the date the last of the line items for the document were shipped.

Discount Date: The date the discount available expires. Will be 00/00/00 if the Terms Discount Available is
Zero or if the SOP Type is a Quote, Return or Back Order.

Due Date: This field contains the due date for the transaction that is being entered.
Only used on SOP Types 1-3; otherwise, leave this field blank.

Repeating: Used on Repeating Quotes or Orders. In SBF, this field is always set to a value of 0. This field is not exposed in the SBF user interface.
0 = Non-repeating document
1 = Repeating

TRX Frequency: The length of time before the document repeats itself. In SBF, this field is not available.
1 = Weekly
2 = Biweekly
3 = Semimonthly
4 = Monthly
5 = Bimonthly
6 = Quarterly
7 = Miscellaneous

Times Repeated: Incremented each time the document is transferred. In SBF, this field is not available.

Times To Repeat: Number of times the document will repeat. In SBF, this field is not available.

Days to Increment: Only used when the TRX Frequency field is 8, Miscellaneous.
If the TRX frequency is Miscellaneous, this field contains the number of days that the document date should be incremented by each time the document is repeated. This field is only used for a quote or an order. In SBF, this field is not available.

Date Last Repeated: The last time the repeating document was transferred. Updated with the user date at the time of transfer. In SBF, this field is not available.

Dest Batch 1: This field contains the Batch ID to be used when the document is transferred. In SBF, this field is not available.

Dest Batch 2: This field contains the Batch ID to be used when the document is transferred. In SBF, this field is not available

Use Document ID1: The Document ID to be used when the document is transferred. In SBF, this field is always set to a value of STANDARD when the SOP TYPE is 2 (Order) or 3 (Invoice). This field is not exposed in the SBF user interface.

Use Document ID2: The Document ID to be used when the document is transferred. In SBF, this field is always set to a value of STANDARD when the SOP TYPE is 1 (Quote) or 2 (Order). This field is not exposed in the SBF user interface.

Discount Available
Freight: The discount available calculated on the freight amount. This field is used in some tax calculations.

Discount Available
Misc: The discount available calculated on the miscellaneous amount. Used in some tax calculations.

Discount Available
Amount: The amount of the discount available on debit type documents, e.g. Quote, Order, Invoice.

Discount Returned: The amount of discounts returned for Return documents only.

Discount Taken
Amount: Amount of discount taken on the document (Not used on Return documents).

Discount Percent
Amount: Used to determine the Discount Available Amount. This field is multiplied by the Total invoice amount to calculate the Discount Available Amount. (Not used if Payment Terms ID is being used).

Discount Dollar
Amount: When a value exists in this field, it will override the setting in the SY_Payment_Terms file for calculating Discount Amount Available for this transaction only. If there is a value in the Discount Percent Amount field, this field will be empty.

Discount Available
Taken: This field contains the total amount of discounts available that have been taken.

Payment Terms ID: Payment terms ID select for this transaction. The payment terms ID should exist in the
SY_Payment_Terms_MSTR file.

Price Level: The default price level for a customer.

Location Code: The site id for the transaction. In SBF, this field is always set to a value of MAIN. This field is not exposed in the SBF user interface but can be changed through the constant SBM_IV_SITEID.

Batch Source: A string value indicating the batch source for the transactions in the batch.
This field should contain Sales Entry or getmsg (SOP_BATCH_SOURCE)) if a batch is entered. When importing, use 'Sales Entry'.

Batch Number: The name of the batch which is saved on the transaction document. It can be re-used once an existing batch has been posted, provided the batch was not a recurring batch. For real-time transactions, a batch record is created using the User ID as the batch number. In SBF, this field is always set to a value of SALES. This field is not exposed in the SBF user interface but can be changed through the constant SBM_SOP_BATCHID.

Customer Number: This field contains a unique ID used to identify each customer. It must exist in the RM_Customer_Master file.

Customer Name: The full name for the Customer (up to 30 characters).

Customer PO Number: This field can be used to track P.O. numbers and print them on invoices or returns.

Prospect: 0 = Existing Customer
1 = Prospect
In SBF, this field is always set to a value of 0. This field is not exposed in the SBF user interface.

Master Number: The master number of the document (Zero (0) indicates master numbers are not being tracked).

Packing Slip Number: The next Packing Slip Number from SOP Setup. If a packing slip is printed from Invoice Entry, this field will contain the packing slip number.

Picking Ticket Number: The next Picking Ticket Number from SOP Setup. Filled in before the Picking Ticket is printed.

Markdown Amount: Total of the Markdown Amount fields in the corresponding SOP_LINE_WORK records.

Primary Billto Address
Code: The address code of the Billto address.

Primary Shipto
Address Code: The address code of the Shipto address.

Contact Person: Name of Contact at Customer site.

ShipToName: Name of the Customer to ship to. Frequently used for drop ship items.

Address 1: Line 1 of the address for the Shipto Address.

Address 2: Line 2 of the address for the Shipto Address.

Address 3: Line 3 of the address for the Shipto Address.

City: City for the Shipto Address.

State: State for the Shipto Address.

Zip Code: Zip Code for the Shipto Address.

Country Code: Country Code for the customers address.

Country: Country for the Shipto Address.

Phone Number 1: Phone number 1 from the Shipto address.

Phone Number 2: Phone number 1 from the Shipto address.

Phone 3: Phone number 3 from the Shipto address.

Fax Number: The fax number for the Shipto address.

Commission Applied
To: This field contains information about how to calculate sales amounts for commission’ calculations.
0 = Sales
1 = Invoice Total

Commission Amount: Total of all corresponding SOP_Commission_WORK_HIST records for this transaction.

Commission Sale
Amount: Amount of the sale used to calculate commissions.

Non-Commissioned
Amount: The dollar amount not used for calculating commissions.

Shipping Method: Shipping method used by this Customer. It is set up in the Shipping Method Maintenance window (in SBF, the Shipping Methods Setup window), i.e. it must exist in the SY_Shipping_Method_MSTR file.

Trade Discount
Amount: This field contains the dollar discount that will be applied to the invoice.

Trade Discount
Percent: The value in this field is multiplied by the Subtotal of the document.
The result is placed in the field Trade Discount Amount.

Subtotal: The running total of the line items' extended price.

Remaining Subtotal: The sum of Remaining Price fields in the related SOP_LINE_WORK records.

Extended Cost: The total of all the extended costs of the line items. Updated when posting.

Freight Amount: The amount in this field is the amount of freight listed on the invoice.

Misc Amount: This amount is used to determine the Misc Tax Amount.

Tax Engine Called: Set to 1 for true. This field indicates whether the tax engine has been run.

Tax Exempt 1: For customer reference only. May store a tax-exempt field. In SBF, this field is not available.

Tax Exempt 2: For customer reference only. May store a tax-exempt field. In SBF, this field is not available.

Tax Registration
Number: This field is where the user can type the customer or vendor's tax registration number. It will eventually appear as the default value in the customer or vendor address card. In SBF, this field is not available.

Tax Schedule ID: The ID for the Tax Schedule. The tax schedule should exist in the TX_Schedule_MSTR file.

Tax Schedule Source: Where the tax schedule defaults from (Internal use only).

Based On Invoice
Total: This field contains information regarding whether the line item contains taxes that are based on the invoice total.
0 – False. The line items do not contain taxes based on the invoice total.
1 – True. The line items do contain taxes based on the invoice total.

Freight Schedule ID: The Tax Schedule ID used to determine which tax details are applicable for the freight amount field. There must be a record in the TX_Schedule_MSTR file with this ID.

Freight Tax Amount: The tax amount calculated based on the 'Freight Amount' field. This field is needed for backing out tax included with item price.

Freight Taxable: The values in this drop down list are used to determine if taxes should be calculated on the Freight Amount.
1 = Taxable
2 = Nontaxable
3 = Base on customers

Misc Schedule ID: The Tax Schedule ID used to determine which tax details are applicable for the Misc Amount field. There must be a record in the TX_Schedule_MSTR_HDR file with this ID.

Misc Tax Amount: The tax amount calculated based on the 'Misc Amount' field. This field is needed for backing out tax included with item price.

Misc Taxable: The values in this drop down list are used to determine if taxes should be calculated on the Misc Amount.
1 = Taxable
2 = Nontaxable
3 = Base on customers

Backout Freight
Amount: If there is a Tax included with item price detail, this is the true Freight amount.

Backout Misc
Amount: If there is a Tax included with item price detail, this is the true Misc amount.

Backout Tax Amount: If there was Tax included with item price detail, this is the total tax amount.

Taxable Tax Amount: The total of all tax amount fields in the SOP_Tax_WORK_HIST table which are marked as Taxable Tax.

Tax Amount: The amount in this field is the amount of tax listed on the invoice. This field will not show any tax amounts calculated for Tax Included With Item Price tax details.

EC Transaction: Used for VAT Line Analysis. Only available if Enable VAT Line Analysis is marked in Company Setup. In SBF, this field is not available.

Document Amount: The total amount of the transaction.

Payment Received: The amount received as payment on an Invoice transaction.

Deposit Received: The amount of payment received on an Order transaction.

COD Amount: This field is for user reference only. If all or part of the invoice will be paid upon delivery, this amount can be stored in this field.

Account Amount: For debit documents, this field should be the document amount minus payments received minus discounts taken. For credit documents, the amount on this field should be the document amount minus the amount applied minus payments.

Sales Territory: This field contains the ID for sales territories a customer is in. In SBF, this field is always set to a value of DEFAULT. This field is not exposed in the SBF user interface, because sales territories are not supported in SBF.

Salesperson ID: This field contains the ID for the salespersons for the customer.

UPS Zone: UPS zone for the document.

Times Printed: The number of times the document has been printed (not updated for Packing Slip or Picking Ticket).

Posting Status: Leave blank or set to 0 for unposted documents.

Void Status: This field stores a flag that marks if the document has been voided.
0 = Document has not been voided.
1 = Document has been voided.

Allocate By: This field indicates how the items should be allocated. In SBF, this field is always set to a value of 1. This field is not exposed in the SBF user interface.
0 = Document/Batch
1 = Line Item

Note Index: The Index of the note for this document, linked to the Record Notes Master.
Not recommended to import into this field.

Currency ID: If MC is registered and this a MC transaction then the MC currency. In SBF, this field is not available. Multiple currencies are not supported in SBF.
If non-MC transaction, set to Functional Currency ID.
If MC is not registered, then leave empty.

Currency Index: The index corresponding to the currency id assigned to this transaction. In SBF, this field is not available. Multiple currencies are not supported in SBF.
Leave empty if MC is not registered.
Set to Functional Currency Index if MC is registered and this is a non-mc transaction.

Rate Type ID: A unique string describing a rate type identifier. Only used on a MC transaction. In SBF, this field is not available. Multiple currencies are not supported in SBF.

Exchange Table ID: A unique string describing an exchange table identifier. Only used on a MC transaction. In SBF, this field is not available. Multiple currencies are not supported in SBF.

Exchange Rate: Exchange Rate of the transaction. If not a multi-currency transaction, leave blank. If there is triangulation and both rates are fixed, this is the originating to euro fixed rate. Otherwise this is the variable rate. In SBF, this field is not available. Multiple currencies are not supported in SBF.

Denomination Exchange
Rate: Fixed Denomination Exchange Rate. In SBF, this field is not available. Multiple currencies are not supported in SBF.
The exchange rate between the Euro currency and a denomination currency. It has a value in the asterisked branches of the following scenarios:
(1) Non-Denomination -> *Euro -> *Denomination
(2) *Denomination -> *Euro -> Non-denomination
(3) Denomination -> *Euro -> *Denomination

The denomination exchange rate from the transaction record. If there is triangulation, this is the fixed rate. If both rates are fixed, this is the euro to functional fixed rate. If there is no triangulation, this is 0.0

Exchange Date: The date used to create an exchange rate. In SBF, this field is not available. Multiple currencies are not supported in SBF.
The Date from the Exchange Table if the 'Use Rates Without Adding to Table' is not marked. Otherwise, the Exchange Date for this MC Trx only..

Time: The Time from the Exchange Table if the 'Use Rates Without Adding to Table' is not marked. Otherwise, the Time for this MC transaction only. In SBF, this field is not available. Multiple currencies are not supported in SBF.

Rate Calculation Method: Indicates whether the exchange table will use multiply or divide rates. (this value cannot be changed once rates are added, the rates will either be multiply or divide). In SBF, this field is not available. Multiple currencies are not supported in SBF.
0 = Multiply
1 = Divide

MC Transaction State: This field holds the value of what state the system was in when the transaction was posted. There are nine different scenarios.
1. Non-denomination -> Non-denomination - EX: A functional currency of USA. Entering a CAN transaction. A Euro Currency ID is setup in the system.
2. Non-denomination -> Euro - EX: A functional currency of Euro. Entering a USA transaction.
3. Non-denomination -> Euro -> Denomination - EX: A functional currency of French Francs (FF). Entering a USA transaction.
4. Denomination -> Euro -> Non-denomination - EX: A functional currency of USA. Entering a FF transaction.
5. Denomination -> Euro -> Denomination - EX: A functional currency of Deutche Marks (DM). Entering a FF transaction.
6. Denomination -> Euro - EX: A functional currency of Euro. Entering a FF transaction.
7. Euro -> Denomination - EX: A functional currency of FF. Entering a Euro transaction.
8. Euro -> Non-denomination - EX: A functional currency of USA. Entering a Euro transaction.
9. No Euro Currency ID - EX: A functional currency of USA. Entering a CAN transaction. There is no Euro Currency ID or all Denomination Currency ID's are disabled.

Acceptable Values and Constants:
0 = MC_NOEURO
1 = MC_NONDENOM_TO_NONDENOM
2 = MC_NONDENOM_TO_EURO
3 = MC_NONDENOM_TO_DENOM
4 = MC_DENOM_TO_NONDENOM
5 = MC_DENOM_TO_DENOM
6 = MC_DENOM_TO_EURO
7 = MC_EURO_TO_DENOM
8 = MC_EURO_TO_NONDENOM
OR
0 = Euro currency is not created or no denomination currencies are enabled.
1 = Originating is not a denomination; Functional is not a denomination
2 = Originating is not a denomination; Functional is the Euro currency.
3 = Originating is not a denomination; Functional is a denomination.
4 = Originating is a denomination; Functional is not a denomination.
5 = Originating is a denomination; Functional is a denomination.
6 = Originating is a denomination; Functional is the Euro currency.
7 = Originating is the Euro currency; Functional is a denomination.
8 = Originating is the Euro currency; Functional is not a denomination.

TRX Source: This stores an internally assigned audit trail code that gets saved on the record at the time the transaction is posted.

SOP HDR
Errors 1: Multiselect list box used to track header level posting errors with the following possible errors:

1 **ERROR: No customer record exists for this customer ID.
2 **ERROR: This customer is inactive.
3 **ERROR: No record exists for this salesperson.
4 **ERROR: No tax schedule or detail exists for this ID.
5 **ERROR: The date is missing or invalid.
6 **ERROR: The payment number is missing or invalid.
7 **ERROR: The document total is incorrect.
8 **ERROR: This document has already been posted.
9 **ERROR: No customer summary record exists for this customer ID.
10 **ERROR: Duplicate document numbers are not allowed.
11 **ERROR: No record exists for this checkbook ID.
12 **ERROR: The document type is invalid.
13 **ERROR: The on-account amount is incorrect.
14 **ERROR: A discount cannot be taken without an amount received.
15 **ERROR: The commission total does not equal the commission amounts.
16 **ERROR: The General Ledger posting date is missing or invalid.
17 **ERROR: General Ledger cannot be updated. Revert to backup if possible.
18 **ERROR: The cash distribution(s) does not equal the actual amount.
19 **ERROR: The discount taken distribution(s) does not equal the actual amount.
20 **ERROR: The receivables distribution(s) does not equal the actual amount.
21 **ERROR: The disc. available distribution(s) does not equal the actual amount.
22 **ERROR: The other distribution(s) does not equal the actual amount.
23 **ERROR: The sales distribution(s) does not equal the actual amount.
24 **ERROR: The trade discount distribution(s) does not equal the actual amount.
25 **ERROR: The freight distribution(s) does not equal the actual amount.
26 **ERROR: The miscellaneous distribution(s) does not equal the actual amount.
27 **ERROR: The taxes distribution(s) does not equal the actual amount.
28 **ERROR: The COGS distribution(s) does not equal the actual amount.
29 **ERROR: The inventory distribution(s) does not equal the actual amount.
30 **ERROR: The returns distribution(s) does not equal the actual amount.
31 **ERROR: The sales tax distribution(s) does not equal the actual amount.
32 **ERROR: The freight tax distribution(s) does not equal the actual amount.

SOP HDR Errors 2: Multiselect list box used to track header level posting errors with the following possible errors:

1 **ERROR: The miscellaneous distribution(s) does not equal the actual amount.
2 **ERROR: The debit distributions do not equal the credit distributions.
3 **ERROR: Distributions are missing or invalid.
4 **ERROR: No account has been specified for one or more distributions.
5 **ERROR: The distribution type is missing or invalid.
6 **ERROR: One or more line items contain errors.
7 **ERROR: You cannot post any more until Sales Order Processing is registered.
8 **ERROR: The payment date is missing or invalid.
9 **ERROR: Cannot enter a discount taken without one or more payments.
10 **ERROR: Severe error adjusting commissions. Revert to backup if possible.
11 **ERROR: Transaction has been voided.
12 **ERROR: Severe error adjusting taxes. Revert to backup if possible.
13 **ERROR: Unable to obtain Receivables document number.
14 **ERROR: Tax distributions do not match the tax amount.
15 **ERROR: This document contains one or more posting holds.
16 **ERROR: Customer is on hold.
17 **ERROR: The markdown distribution(s) do not equal the actual amount.
18 **ERROR: The date is not in the current fiscal year.
19 **ERROR: The fiscal period is closed.
20 **ERROR: The Period Setup information is missing or incomplete.
21 **ERROR: Batch level errors were encountered.
22 **ERROR: A distribution contains both a debit and a credit amount.
23 **ERROR: The payment distributions do not equal the amount received.
24 **ERROR: The non-commission total does not equal the non-commission amounts.
25 **ERROR: No record exists for this sales territory.
26 **ERROR: The commission sale total does not equal the commission sale amounts.
27 **ERROR: The payment number is not reserved in Receivables Management.
28 **ERROR: Severe error adjusting Inventory. Revert to backup if possible.
29 **ERROR: Terms discount taken can't be greater than the document total.
                                          30 **Terms dicount taken is greater than terms discount available.
                                          31 Transaction Analysis information for this transaction is incorrect or missing.
                                          32 This transaction contains multicurrency error(s).

SOP LINE Errors: Multi-select list box used to track line item level posting errors with the following possible errors:

1 **ERROR: Item's master record does not exist.
2 **ERROR: Item's site record does not exist.
3 **ERROR: Serial numbers and item's extended quantity do not balance.
4 **ERROR: Lot quantities and item's extended quantity do not balance.
5 **ERROR: Serial number already exists for this item in the Serial Number file.
6 **ERROR: Serial number missing for the item and site in the Serial Number file.
7 **ERROR: Lot number missing for this item and site in the Lot Number file.
8 **ERROR: Line accounts are missing or invalid.
9 **ERROR: Returned quantities not distributed properly.
10 **ERROR: Lot number already exists for the item in the Lot Number file.
11 **ERROR: Intrastate information is missing or invalid.
12 **ERROR: Line quantity is zero.
13 **ERROR: Severe error adjusting Inventory. Revert to backup if possible.
14 **ERROR: Line quantity not completely distributed.
15 **ERROR: A portion of the line quantity is set to back order.
16 **ERROR: Line quantity is not properly allocated.
17 **ERROR: Line quantity is not properly fulfilled.
                                         18 **ERROR: Serial number quantity type is invalid.
                                          19 **ERROR: Lot number quantity type is invalid.
                                          20 **ERROR: A qty isn’t available to sell for this lot.
21 **ERROR: Item changed to use ave. cost. Doc. date is from before cost change.

SOP HDR Flags: This field is used to indicate if the freight amount and misc amount for a document have been transferred.
1 = Freight Transferred
2 = Misc Transferred
3 = Trade Discount Transferred

SOP MC Posting Error
Messages: 1 The currency ID is missing.
2 This company does not have access to this currency ID.
                                          3 The currency ID is inactive for this company.
                                           4 The rate type ID is missing.
                                5 The rate type ID is not associated with the currency ID for this transaction.
                                           6 The exchange table ID is missing.
                                           7 The company does not have access to this exchange table ID.
                                           8 The exchange table ID is inactive for this company.
                                           9 The exchange rate does not exist.
                                          10 The exchange rate has expired.
                                          11 Cannot post Multicurrency transactions to a recurring batch.
                                          12 The Multicurrency setup information is missing or damaged.
                                          13 The functional currency is missing.
                                14 This company does not have access to the selected functional currency.
                                          15 The functional currency for this company is inactive.
                                          16 Originating debits not equal to originating credits.
                                          17 Originating transaction record missing or damaged.
                                          18 Error occurred while creating Multicurrency record.
                                    19 **ERROR: The fixed exchange rate for the Euro Currency ID could not be found.

Comment ID: The ID of the comment.

Reference: This field is used in General Ledger to enter transaction comments in all General Ledger transaction entry windows.

Posted Date: Used for recurring batches, it records the last date this transaction was posted.

Posted User ID: Used for recurring batches, it records the last user to post this transaction.

User To Enter: The user ID of the user who entered the record storing this value.

Created Date: This field contains the system date of the first save of a document.

Modified Date: Updated with system date each time document is saved.

Tax Date: Date used on VAT reports different from the document date that is used for tax reporting purposes. This can only be entered if VAT Line Analysis is turned on.

Apply Withholding: This field contains information indicating whether this document is subject to withholding.
0 - True = Document is subject to withholding.
1 - False = Document is not subject to withholding.

Withholding Amount: This field contains the withholding amount.

Shipping Document: Flag to indicate that this transaction is a shipping document. In SBF, this field is not available.

Correction: This field indicates whether a transaction corrects another transaction. In SBF, this field is not available.
0 - True = transaction corrects another transaction.
1 - False = transaction does not correct another transaction.

Simplified: Flag to indicate that this transaction is a Simplified transaction. In SBF, this field is not available.

Correction to Nonexisting
Transaction: Flag to indicate that this transaction is a correction to a transaction that doesn’t exist (Beginning balance). In SBF, this field is not available.

Document Number
Corrected: The Document Number being corrected. In SBF, this field is not available.

Sequence Number Corrected: The Sequence Number being corrected (it is possible that a document can be corrected by
more than 1 document). In SBF, this field is not available.

Sale Date: This date field tracks the physical date of transfer of goods/services.

SOP HDR Errors 3: Additional Posting Error Messages.
                                           1 You cannot post to a tax date within a closed tax period.
                                           2 You cannot post to a tax period that has not been set up.
                                           3 ** ERROR: The Total cannot be negative.

Exceptional Demand: Flag indicating demand that is more that what is typical for and item-site.

Flags The Flags field is used to determine if the address attributes on the header have been modified. It will also be used to determine if the header’s comment text has been modified or to track whether the picking ticket or packing slip have been printed. The first four positions of the integer will be used. The first position is to flag the Address Attribute as modified. The second position will be used to flag the comment text as modified. The third position will be used to indicate the packing slip has been printed. The fourth position will be used to indicate the picking ticket has been printed.
1 = SOPFLAGS_ADDREDITED
2 = SOPFLAGS_COMMENTEDITED
3 = SOPFLAGS_PACKINGSLIPPRINTED
4 = SOPFLAGS_PICKINGTICKETPRINTED

Backout Trade Discount
Amount Trade Discount Amount less associated ‘Tax Included in Item Price’ tax.

GPSFO Integration ID Great Plains Front Office only. Holds the primary key of front office records that are integrated to this record.

Integration Source Source of integration. If empty, no product is integrated. If this field has a value, product is already integrated to this record, therefore no other product should overwrite. Unique values are assigned by Microsoft Great Plains for integrating products to use to indicate they are integrated to this record.

Integration ID Empty if Integration Source is empty. Otherwise contains primary key of external system that is integrated with this record. This is for 3rd party integrations into Professional.

SOP Status:  Status of the document. Status, Document Type and constant pairs are below.
SOP Status    SOP Type  Constant
1 - New    Order   SOP_STATUS_NEW
2 - Ready to Print Pick Ticket  Fulfillment Order  SOP_STATUS_READYTOPICK
3 - Unconfirmed Pick  Fulfillment Order  SOP_STATUS_UNCONFIRMEDPICK
4 - Ready to Print Pack Slip  Fulfillment Order  SOP_STATUS_READYTOPACK
5 - Unconfirmed Pack  Fulfillment Order  SOP_STATUS_UNCONFIRMEDPACK
6 - Shipped   Fulfillment Order  SOP_STATUS_SHIPPED
7 - Ready to Post   Invoice   SOP_STATUS_READYTOPOST
8 - In Process   Order   SOP_STATUS_INPROCESS
9 - Complete   Order   SOP_STATUS_COMPLETE

Ship Complete Document: Flag used to determine whether customer is unwilling to accept multiple shipments.

Direct Debit: Document is available for Direct Debit processing.

The following fields must be imported regardless of if Multi-Currency is registered. If the transaction is not a multi-currency transaction, then fill the field with the same value of the corresponding non-mc field. Example: If Discount Available Freight=$3.00, then set Originating Discount Available Freight to the same amount. If Discount Available Freight = $0. Then leave the Originating Discount Available Freight blank also.

Orig Discount Available Freight: The originating discount available freight amount from the transaction.

Orig Discount Available Misc: The originating discount available miscellaneous amount from the transaction.

Orig Discount Available Amount: The originating discounts available amount from the transaction.

Orig Discount Returned: The originating amount of discounts returned. This is only for "Return" type
documents.

Orig Discount Taken Amount: The originating discount taken amount from the transaction record.

Orig Discount Dollar Amount: The originating discount amount from the transaction.

Orig Discount Available Taken: The originating discounts available taken amount from the transaction.

Orig Markdown Amount: The originating markdown amount from the transaction.

Orig Commission Amount: The originating commission amount from the transaction.

Orig Commission Sales Amount: The originating commission sales amount from the transaction.

Orig Non-Commissioned Amount: Non-commissioned amount in the originating currency.

Orig Trade Discount Amount: The originating trade discount from the transaction.

Orig Subtotal: The originating subtotal amount from the transaction.

Orig Remaining Subtotal: The originating remaining subtotal amount from the transaction.

Orig Extended Cost: The originating extended cost of the transaction.

Orig Freight Amount: The originating amount of Freight charges from the transaction record.

Orig Misc Amount: The originating amount of Misc charges from the transaction record.

Orig Freight Tax Amount: Same description as Freight Tax Amount but in the Originating Currency. Set to Freight Tax Amount for non-MC transaction.

Orig Misc Tax Amount: Same description as Misc Tax Amount but in the Originating Currency. Set to Misc Tax Amount for non-MC transaction.

Orig Backout Freight Amount: The originating amount of Freight less any amount of tax calculated for a Tax Included with Item Price tax detail.

Orig Backout Misc Amount: The originating amount of Misc less any amount of tax calculated for a Tax Included with Item Price tax detail.

Orig Backout Tax Amount: The originating backout tax amount of the transaction

Orig Taxable Tax Amount: The originating taxable tax amount of the transaction.

Orig Tax Amount: Tax amount assigned to this detail in the original currency. Set to Tax Amount if non-MC transaction.

Orig Document Amount: The originating document amount from the transaction.

Orig Payment Received: The originating payment received amount from the transaction.

Orig Deposit Received: The originating deposit received amount from the transaction.

Orig COD Amount: The originating COD amount of the transaction.

Orig Account Amount: The originating account amount from the transaction.

Orig Backout Trade Discount Amount: The originating trade discount amount less associated ‘Tax Included in Item Price’ tax.

Disabling buttons on click in ASP.NET

Steve Gray — Wed, 02 Jul 2008 16:36:00 GMT

Just to give props, I found this here: http://geekswithblogs.net/jwhitehorn/archive/2006/06/17/82214.aspx

but I don't like to leave valuable info on the internet, it might get deleted. Plus, I have to spend the 30 minutes hunting it down again <smiles>

We have all seen the websites that disable "submit" buttons when you click on them. This is often done to prevent users from clicking the button multiple times.
Normally this is accomplished using an 'onclick' JavaScript event to disable the button. In ASP.NET, each server side item already has a onclick event handler which calls the server back for event processing.
To accomplish the same thing in ASP.NET, you could easily do:

 Button1.Attributes.Add("onclick", "this.disabled=true;" + ClientScript.GetPostBackEventReference(Button1, "").ToString())

Cursor Template

Steve Gray — Tue, 01 Jul 2008 13:22:00 GMT

This is the cursor template that I use... it works better than the default one, and allows BREAK and CONTINUE easily

 DECLARE curName CURSOR KEYSET FOR 
 select *
  from mytablename
DECLARE variables
OPEN curName
WHILE 1=1 
BEGIN
 FETCH NEXT FROM curSopUpdate23 INTO @sopnumbe,@soptype,@dtOnTruck, @dtOnJob
 if @@fetch_status <> 0 begin
  break
 end 


END
CLOSE curName
DEALLOCATE curName

Subsonic VB Setup

Crystal — Tue, 24 Jun 2008 12:17:00 GMT

Web.config

VisualStudio > Tools > External Tools > Add
Name is Subsonic DAL and browse for the exe file
C:\Program Files\SubSonic\SubSonic 2.0.3\SubCommander\sonic.exe

Arguments: generate/out App_Code\Generated/lang vb

Initial Directory: Project Directory

x Use Output Window x Prompt for arguments

'CrystalReportViewer' is ambiguous in the namespace 'CrystalDecisions.Web'

Steve Gray — Mon, 23 Jun 2008 16:14:00 GMT

Also:

Error 13 'ReportDocument' is ambiguous in the namespace 'CrystalDecisions.CrystalReports.Engine'. C:\projects\Culinart\Culinart\Reports\POSCash.aspx.vb 11 18 C:\...\Culinart\

Error 15 'DiskFileDestinationOptions' is ambiguous in the namespace 'CrystalDecisions.Shared'. C:\projects\Culinart\Culinart\Reports\POSCash.aspx.vb 47 26 C:\...\Culinart\

Error 16 'ExportDestinationType' is ambiguous in the namespace 'CrystalDecisions.Shared'. C:\projects\Culinart\Culinart\Reports\POSCash.aspx.vb 50 57 C:\...\Culinart\

Error 17 'ExportFormatType' is ambiguous in the namespace 'CrystalDecisions.Shared'. C:\projects\Culinart\Culinart\Reports\POSCash.aspx.vb 51 52 C:\...\Culinart\

I solved this by going to Project Propertities > References, somehow I had references to two different versions of crystal in my project. While doing this I noticed that the references kept coming back. I searched the project and found that I had double lines iin the web config to different versions of Crystal.

Grant permissions cursor

Crystal — Fri, 13 Jun 2008 12:43:00 GMT

DECLARE @name varchar(255),
@sql varchar(255)

DECLARE curName CURSOR KEYSET FOR
      select name
            from sys.objects
            where type = 'p'

OPEN curName

WHILE 1=1
BEGIN
FETCH NEXT FROM curName INTO @name

      if @@fetch_status <> 0 begin
            break
      end

SET @sql = 'grant exec on ' + @name + ' to chemsys'
exec (@sql)
END

CLOSE curName
DEALLOCATE curName
GO

RUN my Windows Service without installing and starting it

Steve Gray — Tue, 10 Jun 2008 13:23:00 GMT

I am often asked the question "Can't I just RUN my Windows Service without installing and starting it?".

My answer usually is "No, you can't but..."

There is a "but": you can create your Windows service as a hybrid application, so it will run as a console application also.

Why would you want to do that?
• It makes debugging from within Visual Studio a breeze
• Sometimes you want to show some debugging information in a production environment by using Console.WriteLine()
• You don't always want to install your service to see if it runs in a particular environment
Turning a .NET Windows service into a hybrid application is actually very simple. In your Main() method you add the following:
static class Program
{
static void Main(params string[] parameters)
{
    if (parameters.Length > 0 && parameters[0].ToLower() == "/console")
      new MyService().RunConsole(parameters);
    else
      ServiceBase.Run(new ServiceBase[] { new MyService() });
   }
}
Then, in your service class, add a RunConsole() method:
   public void RunConsole(string[] args)
   {
      OnStart(args);

      Console.WriteLine("Service running... Press any key to stop");

      Console.Read();

      OnStop();
   }
That's all there is to it. To run your service as a console app, just specify "/console" as the first paramter when running the .EXE.

Build a Table from Code

corey — Fri, 23 May 2008 18:07:00 GMT

Set the table on the aspx page to have a runat="server".

<table id="tblReport" runat="server">
    <tr>
        <td width="100" class="ReportSubtitle">
            Unit
        </td>
        <td width="100" class="ReportSubtitle">
            Date
        </td>
        <td width="100" class="ReportSubtitle">
                       
        </td>
        <td width="100" class="ReportSubtitle">
            Cash Deposit
        </td>
        <td width="100" class="ReportSubtitle">
            Proof to Bank
        </td>
        <td width="100" class="ReportSubtitle">
            Initials
        </td>
    </tr>
</table>

In the code behind, add something like:

Public Sub bindData()
        Dim ds As DataSet = CulinartDB.SPs.FpPOSDailySummaryReport(Session("startdate"), Session("enddate")).GetDataSet()


        'get a list of the units in the dataset
        Dim units = (From dr In ds.Tables(0).Rows _
                    Select locndscr = dr("locndscr"), locncode = dr("locncode"), total = dr("TotalCashDeposit")).Distinct()


        For Each u In units
            Dim locn = u.locncode


            'build the header
            Dim rowHeader As New HtmlTableRow()
            Dim cell As New HtmlTableCell()
            cell.ColSpan = 6
            cell.ID = "report_cell_title"
            cell.InnerHtml = u.locndscr
            rowHeader.Cells.Add(cell)
            tblReport.Rows.Add(rowHeader)


            'add the lines
            Dim lines = From dr In ds.Tables(0) _
                        Select docdate = dr("docdate"), cashDeposit = dr("CashDeposit"), totalCashDeposit = dr("TotalCashDeposit"), locncode = dr("locncode") _
                        Where locncode = locn


            For Each l In lines
                Dim row As New HtmlTableRow()
                Dim cName As New HtmlTableCell()
                Dim cDt As New HtmlTableCell()
                Dim cTotalDesc As New HtmlTableCell()
                Dim cCashDeposit As New HtmlTableCell()
                Dim cProof As New HtmlTableCell()
                Dim cInit As New HtmlTableCell()


                'set the properties on the cells
                cName.ID = "report_cell"
                cDt.ID = "report_cell"
                cTotalDesc.ID = "report_cell"
                cCashDeposit.ID = "report_cell"
                cProof.ID = "report_cell_blank"
                cInit.ID = "report_cell_blank"


                'set the cell text
                cDt.InnerText = Date.Parse(l.docdate).ToShortDateString()
                cTotalDesc.InnerText = "Daily Total"
                cCashDeposit.InnerText = CType(l.cashDeposit, Double).ToString("C")
                cProof.InnerHtml = "&nbsp;"
                cInit.InnerHtml = "&nbsp;"


                'add the cells to the row
                row.Cells.Add(cName)
                row.Cells.Add(cDt)
                row.Cells.Add(cTotalDesc)
                row.Cells.Add(cCashDeposit)
                row.Cells.Add(cProof)
                row.Cells.Add(cInit)


                'add the row to the table
                tblReport.Rows.Add(row)



            Next


            'build the footer
            Dim rowFooter As New HtmlTableRow()
            Dim cNameF As New HtmlTableCell()
            Dim cDtF As New HtmlTableCell()
            Dim cTotalDescF As New HtmlTableCell()
            Dim cCashDepositF As New HtmlTableCell()
            Dim cProofF As New HtmlTableCell()
            Dim cInitF As New HtmlTableCell()


            'set the properties
            cNameF.ID = "report_cell"
            cDtF.ID = "report_cell"
            cTotalDescF.ID = "report_cell_title"
            cCashDepositF.ID = "report_cell_title"
            cProofF.ID = "report_cell_blank"
            cInitF.ID = "report_cell_blank"


            'set the text
            cTotalDescF.InnerText = "Unit Total"
            cCashDepositF.InnerText = CType(u.total, Double).ToString("C")


            'add the cells to the row
            rowFooter.Cells.Add(cNameF)
            rowFooter.Cells.Add(cDtF)
            rowFooter.Cells.Add(cTotalDescF)
            rowFooter.Cells.Add(cCashDepositF)
            rowFooter.Cells.Add(cProofF)
            rowFooter.Cells.Add(cInitF)


            'add the row
            tblReport.Rows.Add(rowFooter)


        Next



    End Sub

Disabling a Button when Clicked

corey — Wed, 21 May 2008 16:52:00 GMT

To disable a button when it is clicked, add the following to the load event:

btnSave.Attributes.Add("onclick", "this.disabled=true;" + ClientScript.GetPostBackEventReference(btnSave, "").ToString())

This will cause the button to disable via javascript before the postback happens. This prevents things like credit card transactions from going through more than once.

Used Javascript to check a radio box

Crystal — Wed, 21 May 2008 14:30:00 GMT

In a recent project I needed to check a radio button based on whether or not a text field was populated.

<script language="javascript" type="text/javascript">
    if (document.frmCreateAccount.EMail.value=="")
      {
        document.frmCreateAccount.OKToEMailYes.checked=true;
      }
    else if (document.frmCreateAccount.EMail.value!="")
      {
      }
</script>

Returning the current time in SQL Server

Steve Gray — Thu, 15 May 2008 12:10:00 GMT

From a recent email:

I am trying to use SmartList Builder to build a query where a calculation is required showing the number of days an A/R transaction is past due. Obviously, I have the DOCDATE from RM20101 but I need a column that tells me the current date so I can make this comparison…and I am not sure if there is a SQL Server table that I can pull in that shows this information to me. I am pretty certain that there is not a GP table with current date in it just sitting there by default.

Answer:

Select getdate(), convert(varchar(10),getdate(),101)

Getdate() returns a date/time, the second part will strip the time