ecinternet/sage300account

EC Internet Sage 300 Account

Maintainers

Details

github.com/ECBrands/ECInternet_Sage300Account

Source

Issues

Installs: 108

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 10

Forks: 0

Open Issues: 0

Type:magento2-module

dev-main 2025-01-16 21:04 UTC

Requires

OSL-3.0, AFL-3.0 caea8a112e9602a6a7f7460fd918569ee85aa771

This package is auto-updated.

Last update: 2025-04-14 17:50:53 UTC

README

ecinternet_sage300account - 1.6.9.0

Requirements

Overview

Sage300Account module adds Sage invoice and order history information to the Magento 2 backend for viewing historical invoices and orders.

Installation

  • Unzip the zip file in app/code/ECInternet
  • Enable the module by running php bin/magento module:enable ECInternet_Sage300Account
  • Apply database updates by running php bin/magento setup:upgrade
  • Recompile code by running php bin/magento setup:di:compile
  • Flush the cache by running php bin/magento cache:flush

Configuration

Specifications

Data Changes

order

  • is_invoice_payment
  • uom

order_item

  • invoice_docnumber

sales_order_status

  • invoice_payment_complete

quote_item

  • invoice_docnumber
  • uom

Attributes

Product

  • uom

Features

Notes

  • Adding an invoice payment to the cart will empty the existing cart.
  • Leaving checkout with an invoice payment in your cart will also cause the Customer's cart to be emptied.

Reorder Custom Products - Product Collection Query

SELECT
	cpe.`entity_id`
	,cpe.`sku`
	,csi.`qty_increments`
	,oeshdt.`is_active`
	,oeshdt.`CUSTOMER`
	,oeshdt.`SHIPDATE`
FROM
	catalog_product_entity cpe

LEFT OUTER JOIN
	cataloginventory_stock_item csi
ON
	cpe.`entity_id` = csi.`product_id`

LEFT OUTER JOIN
	ecinternet_sage300account_oeshdt oeshdt
ON
	cpe.`sku` = oeshdt.`ITEM`

WHERE
	csi.`product_id` IS NOT NULL
	AND csi.`qty_increments` > 0
	AND oeshdt.`ITEM` IS NOT NULL

ORDER BY
	oeshdt.`CUSTOMER`, cpe.`sku`

Reorder Custom Products - Requests

  • Add 'uom'
  • Add "Last purchased date"
  • Add +/- to quantity box

Reorder Custom Products - Issues

  • Requesting quantity which does not exist redirects user to product page. We want to block this because these products will have visiliby = 1 so product isn't viewable.

Known Issues

Version History

  • 1.6.9.0 - Customer Account sidenav display now respect store id.
  • 1.6.4.0 - Fix calculation of open invoice amount. Fix calculation of extended price amount for invoice line items.